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 -> How do you compare the data in different schemas not just table diffs

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

From: tony <ramdan_at_mailexcite.com>
Date: 14 Sep 1999 08:54:02 -0500
Message-ID: <ersD3.12722$Dk7.264368@newscene.newscene.com>


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 Tue Sep 14 1999 - 08:54:02 CDT

Original text of this message

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