In addition to the suggestions in the previous post,
consider doing occasional export/import of your main schema into
baseline copies. A number of tools (TOAD, PowerDesigner, Oracle
ChangeManagment?...) will let you compare and produce reports on
comparisons between schemas (some reading the dump files directly).
Another bonus is that some of these tools will also generate scripts to
implement the upgrades to resynch the two schemas.
Depending on your Oracle version and the amount of activity on your
database, you could also try hunting/fishing in the redo log (using log
miner), looking for DDL transactions.
Received on Sat Feb 19 2005 - 06:46:48 CST
