Re: comparing 3 tables from 3 databases

From: Mark Bole <makbo_at_pacbell.net>
Date: Sat, 14 Aug 2004 02:15:49 GMT
Message-ID: <pBeTc.4316$tN6.2713@newssvr27.news.prodigy.com>

Shawn wrote:
>>>>We have 3 databases. Each of these databases have a identical table.
>>>>Each table has anywhere from
>>>>1400-1550 records. The data in these tables was supposed to be
>>>>identical. But they aren't.
>>>>So, I need to compare the table in each database to determine the
>>>>exact differences of the data.
>>>>Any suggestions on how to best complete this task would be greatly
>>>>appreciated!
>>>>
>>>>Thanks,
>>>>Shawn
>>>>
>>>

[...]

> 
> What if the databases aren't linked?  Each database represents
> separate/distinct financial activity and I think they keep them apart for
> audit reasons?
> 
> Thanks,
> Shawn
> 
>

If the databases aren't linked in real time, then make a copy. As previously mentioned, you can't compare if you can't access.

Also, consider the supplied package DBMS_RECTIFIER_DIFF as an alternative to MINUS operator.

--Mark Bole Received on Fri Aug 13 2004 - 21:15:49 CDT