RE: script for comparing two schemas in two databases

[kkennedy]

Title: script for comparing two schemas in two databases

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-----
From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002 2:18 AM
To: Multiple recipients of list ORACLE-L
Subject: script for comparing two schemas in two databases

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