RE: Compare data between 2 tables (same columns) in different schemas
Date: Mon, 17 Aug 2015 14:13:58 +0000
Message-ID: <D4EBD31A58EB64419330A4F471BB2F242673347B_at_CINURCNA02.e2k.ad.ge.com>
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Aug 17 2015 - 16:13:58 CEST