Re: comparing 3 tables from 3 databases

"Ana C. Dent" <anacedent_at_hotmail.com> wrote in message news:Xns9541B4DD0C7FFSunnySD_at_68.6.19.6...
> "Shawn" <spedwards_at_x.qwest.net> wrote in
> news:4HbSc.13$ah5.102082_at_news.uswest.net:
>
> > 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
> >
>
> SELECT * FROM TABLE_A
> MINUS
> SELECT * FROM TABLE_A_at_REMOTE1;
I'd extend that to

select * from
(SELECT * FROM TABLE_A
MINUS
SELECT * FROM TABLE_A_at_REMOTE1)
union
(SELECT * FROM TABLE_A_at_REMOTE1
MINUS
 SELECT * FROM TABLE_A) etc

and we are both assuming that the table *definitions* are the same but the data is different.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com