CODEWITHSUNDEEP
databaseoracle-database
Jaroslav Záruba
Jaroslav Záruba

Reputation: 4876

Create and compare snapshots of a schema definition

I want to take a snapshot of all table, view and procedure definitions, and diff this snapshot against another version of the same schema. (By snapshot I mean the schema definition stored in some text file.)
I am not interested in procedure bodies, only in what is relevant to my DAOs. (Maybe you could call that a schema interface...?) Is there a one-command way of creating such snapshot for an Oracle schema?

Upvotes: 0

Views: 231

Answers (1)

BA.
BA.

Reputation: 934

You can use Oracle SQL Developer "Database Diff" to do this. You can select the two Oracle schemas to be compared and it produces all the differences

The good thing about this tool is that it allows you to select what to consider when differences are produced, and, then, you have the option of only comparing package specs

Upvotes: 1

Related Questions