Re: comparing Oracle databases

You could try using ERwin from Logic Works. ERwin will reverse engineer any number of databases, store them as Entity-Relationship diagrams. You can then compare the two. Once differences are determined, ERwin will generate alter scripts to make one look like the other (in either order!).

-- 

Steve Liebler              [http://www.logicworks.com]
Senior Product Consultant  stevel_at_logicworks.com
Logic Works, Inc.          Phone: 609.514.2037

****************************************
*       Introducing ModelMart.         *
*   Now you can share ERwin models     *
*       without losing control         *
****************************************

Jack L. Swayze Sr. <keystrk_at_feist.com> wrote in article
<50nsq2$rrt_at_wormer.fn.net>...


> Ayrton Sargusingh SBR/SST/DREO (asargusi_at_sbrsim.ed.dreo.dnd.ca) wrote:


> >Hi everyone:


 


> >I have a particular problem with project I'm working on. A 

> >contractor of ours has modified a copy of a rather large 

> >database. Does anyone know if or how I could compare both

> >the old and the new databases? Performing oracle dumps of

> >both databases does not appear to help; since dump files are

> >not plain ASCII text files, they cannot be diff'ed. 

> 

> Use MINUS !!  

> 

> to see differences in the table structure:

> 

> select * from user_tab_columns_at_the_remote_DB

> minus

> select * from user_tab_columns;

> 

> AND:

> 

> select * from user_tab_columns

> minus

> select * from user_tab_columns_at_the_remote_DB;

> 

> 

> THEN:

> 

> for each table:

> 

> select * from A_TABLE_at_the_remote_DB

> minus

> select * from A_TABLE;

> 

> AND:

> 

> select * from A_TABLE

> minus

> select * from A_TABLE_at_the_remote_DB;

> 

> ------------------------------------------------------------

> 

> 'Keystroke'

> KeystrkTX_at_AOL.COM

> 

>