Re: Comparing two databases

BEERYR <Ron.Beery_at_DaytonOH.ATTGIS.COM> writes:

>Any suggestions or third party tools that will compare objects in one
>database to another database. This would include: tables, indexes,
>triggers, stored procedures, database links, grants, synonyms, views,
>constraints, sequences, and user definitions. Basically, anything
>that makes one database different from another.
 

>This would be used to compare development to production
>or a customized db to the plain vanilla db. Or a pre-upgrade
>db to a post-upgrade db.

_____________Ari's Comments follow____________________________________________

There is an elegant way to compare objects in two databases. Create a database link from one to the other. Then you can type something like:

SELECT TABLE_NAME FROM ALL_TABLES
minus
SELECT TABLE_NAME FROM ALL_TABLES_at_instance2;

SELECT TABLE_NAME FROM ALL_TABLES_at_instance2 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.

Best of luck to you,

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> Visit my Web Page: http://homepage.interaccess.com/~akaplan   <->
<->             email: akaplan_at_interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->






_________________Ron's Article Continues...___________________________________

>Another idea would be take an export full=y rows=n of both db's
>then have a unix script to compare them. But, optionally, ignre
>differences due to extent sizing and such.
 

>Any ideas.
 

>Ron Beery
>NCR
>"Everything is computerized. What could possibly go wrong?"
Received on Thu Jun 27 1996 - 00:00:00 CEST