Re: Whats the best way to see what changes have been made to a database structure?

A simple group by on the dba_objects or user_objects will give you the counts by object_type which will let you see where new objects were added or perhaps dropped.

You can write an outer join of the dba_tab_columns dictionary view to identify differences in the column lists of tables and views. By using an outer join or perhaps full outer join you can make missing and new objects show up.

You can join dba_ind_columns to comapre indexes equal

etc...

How hard this is really depends on how fancy you want the identification of the differences to be.

HTH -- Mark D Powell -- Received on Fri Feb 18 2005 - 16:53:29 CST