Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Database Compare Script

Re: Database Compare Script

From: Yechiel Adar <adar76_at_inter.net.il>
Date: Fri, 14 Nov 2003 01:14:25 -0800
Message-ID: <F001.005D69AA.20031114011425@fatcity.com>


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

  I am looking for a script to compare an entire database instance against another. (From system_at_instance, 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: michael.cupp_at_wpafb.af.mil

  ( Phone: 937-255-1982 DSN 785-1982

  2 Fax: 937-656-4308 DSN 986-4308

                             Bldg 45, Room 062

                             2130 8th St

                             WPAFB OH 45433




--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Yechiel Adar
  INET: adar76_at_inter.net.il

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Nov 14 2003 - 03:14:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US