DBMS_COMPARISON will do what you want (even will do it across DBs using
dblinks).
However, think about what you’re asking for. If you’re comparing the data in
table1 and table2, and neither have a primary or unique key, you’re going to
end up with a Cartesian product. For every row read in table1, it’s going to
have to do a full table scan to find whether or not the row exists in table2.
Not an optimal solution for any size table except very small.
Matt
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Eriovaldo Andrietta
Sent: Monday, August 10, 2015 12:33 PM
To: ORACLE-L
Subject: Compare data between 2 tables (same columns) in different schemas
Is there any Oracle resource to compare data between 2 tables (same columns) in
different schemas ?
I use PL/SQL Developer. It does it.
But it requests a primary key in the table. Some tables does not have it.
Regards
Eriovaldo
