Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: comparing two table
Hi
Check out the procedure DBMS_RECTIFIER_DIFF.DIFFERENCES
This should do what you want.
Alistair
"alainc" <alain2208_at_caramail.com> wrote in message
news:b05rs8$9fq$1_at_s1.read.news.oleane.net...
> Hello,
> i need to compare two table contents in two database (replication problem)
> so i need to compare not only one column but all.
> is there something easy to do not comparing all the column with his
> conuterpart on the other database?
> because i need to compare more than one table and that will be very long
to
> make the query.
>
> thanks
>
> Alain
>
>
Received on Thu Jan 16 2003 - 03:51:59 CST