Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Compare Databases How ?

Re: Compare Databases How ?

From: Lee Miller <lpm_at_newsguy.com>
Date: Tue, 6 Feb 2001 12:55:02 -0500
Message-ID: <95pdpl02kdb@enews4.newsguy.com>

Depending on what level of granularity you want you can home brew some queries to compare them yourself

Assuming database2 is being set up to be a copy of database 1 (and there is nothing in database2 you need to replicate to database1 I'd start with:

(SELECT * FROM all_objects_at_database1)
MINUS
(SELECT * FROM all_objects_at_database2)

then

(SELECT * from all_tab_columns_at_database1) MINUS
(SELECT * from all_tab_columns_at_database2)

And in general just run through all the objects returned by

SELECT object_name FROM all_objects WHERE object_name LIKE 'ALL_%'

comparing each with a SELECT ... MINUS ... SELECT

Akram JARO wrote in message ...
>Hi,
>
>can anyone tell me please if there is any any kind of tools to compare to
>large databases.
>(oracle 8.0.4, WinNT4.0)
>i would like to have the differint records in the databasees and if can i
>compare more than 2 databases in the sametime ?
>
>and i would to compare 2 tables .
>
>can anyone help me please ????
>
>send me email please:
>
>akramj_at_erstebank.com
>
>Akram JARO
>
>
Received on Tue Feb 06 2001 - 11:55:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US