Re: comparing Oracle databases

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 Received on Fri Sep 06 1996 - 00:00:00 CEST