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: script for comparing two schemas in two databases

RE: script for comparing two schemas in two databases

From: Kevin Lange <kgel_at_ppoone.com>
Date: Wed, 29 May 2002 14:10:08 -0800
Message-ID: <F001.0046EDEA.20020529141008@fatcity.com>


I came to that conclusion as well. I especially like the fact that it even creates a sync script after the compare.

I just used it on two of our DBs. Worked great.

-----Original Message-----
Sent: Wednesday, May 29, 2002 4:54 PM
To: Multiple recipients of list ORACLE-L

Kevin,
 You should download the ver 7.3 of TOAD. It has a lot of improvements that You might find handy.
Ron
ROR mª¿ªm

>>> kkennedy_at_firstpoint.com 05/29/02 01:24PM >>>
Years ago, I found a script on Metalink that worked decently after a few bug fixes. It was written by Ottar Sorland for use with Oracle 7.3.  I still occasionally use it and can send my patched (but still not perfect) version if you need it.  

Lately, I've been using a TOAD feature (version 7.2 with DBA option) that works much better. I haven't tried the OEM tool.  

Kevin Kennedy
First Point Energy

-----Original Message-----
Sent: Wednesday, May 29, 2002 2:18 AM
To: Multiple recipients of list ORACLE-L

Hi!

Does anybody out there have a script that allows me to compare two schemas in two different databases (i.e. development and production db)?

This is 8.1.7 on Sun Solaris.

Thanks,
Helmut

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Lange
  INET: kgel_at_ppoone.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Wed May 29 2002 - 17:10:08 CDT

Original text of this message

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