Re: How do you compare the data in different schemas not just table diffs

you can do a lot with the minus operator and it is suprisingly efficient. if you're talking massive amounts of data, there is no quick way to do what you want. here is an example with minus.

select * from user1.table1
MINUS
select * from user2.table1;

i don't believe minus will support lobs or longs but you can run it on all the other columns. you will probably want to run the comparison in both directions.

gene hubert
skillspoint.com

On 14 Sep 1999 08:54:02 -0500, ramdan_at_mailexcite.com (tony) wrote:

>I have two schemas that have the same exact tables but the data might be
>slightly different.
>
>I can compare the tables difs via TOAD, BUT is there a way to compare the
>actual data in the tables without having to do not exists statements on each
>table one by one.
>
>Is there some way to do this without manually doing it for every tables does
>anybody have or know of a script?
Received on Wed Sep 15 1999 - 21:22:55 CDT