Re: Database Compare Script

[Yechiel Adar]

Take any tool that does compare schema, trace it, and put a wrapper that will activate the script for all schemas in the database. If you have TOAD you can easily capture the sql via spool sql to file (or screen).   For your side note: restore a backup to the test system. If you need only the structure use the DataBee tool to copy the structure from prod to test.   Yechiel Adar Mehish ----- Original Message ----- From: Cupp Michael E Contr Det 1 AFRL/WSI To: Multiple recipients of list ORACLE-L Sent: Thursday, November 13, 2003 9:59 PM Subject: Database Compare Script I am looking for a script to compare an entire database instance against another.  (From [EMAIL PROTECTED], etc).   I do not want something that has to be done by schema, as I have 50+ schema's to compare.       ALSO - on a side note, is there an 'easy' way of duplicating a PRODUCTION database over to test, without copying the db files?   --- Michael E. Cupp, Jr. (tm)    Email:       [EMAIL PROTECTED] (  Phone:     937-255-1982         DSN 785-1982 2  Fax:         937-656-4308         DSN 986-4308 -  Location:    DET 1 AFRL/WSI                            Bldg 45, Room 062                            2130 8th St                            WPAFB OH 45433