-
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 [url]http://www.ezsql.net[/url] . 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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|