Thanks Matt
It makes sense.
This task is not usual.
I need to do only once. I can choose tables or wait for comparison of all
tables.
The activity is a double check after apply :
flashback database to restore point rbk001;
Thanks
Eriovaldo
2015-08-17 11:13 GMT-03:00 Adams, Matthew (GE Appliances) <MATT.ADAMS@xxxxxx
:
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