Script to compare objects in two instances

Does any of you have a script to compare objects in two instances? Will appreciate it if you can send it to me. I need that urgently today. Thanks, Rong

Hi,

I dont have a script but this is another way of getting it.

SELECT TABLE_NAME FROM ALL_TABLES
minus
SELECT TABLE_NAME FROM ALL_TABLES@ins2;

SELECT TABLE_NAME FROM ALL_TABLES@ins2
minus
SELECT TABLE_NAME FROM ALL_TABLES;

You will then get a list off all tables in one instance that is not in the other. You can also do this for sequences (ALL_SEQUENCES), procedures
(ALL_SOURCE), etc.

-Anand

Hi
try the free tool called ezsql from http://www.ezsql.net . This tool have an option for comparing two instances/schemas


Santosh

Oracle Entreprise Manager : Change management Pack

Gert

Thank you all for replying. I end up using the DBArtisan Change Management. Tried OEM. I think it only came with 2.1 version while what we have on CD is an earlier version. So I had to download it. Took me an hour or so and somehow during the process the file gets corrupted. So I cannot unzip it nor install it. Well anyway the DBArtisan seems to work fine for me. Thanks again! ROng