RE: Compare data between 2 tables (same columns) in different schemas

From: Jeff Smith <jeff.d.smith_at_oracle.com>
Date: Mon, 10 Aug 2015 10:52:33 -0700 (PDT)
Message-ID: <c8695dee-f0c8-4899-abc1-aa6c8b967ffc_at_default>

Many folks aren’t aware of DBMS_COMPARISON package – it can do data compares between two tables.

 

From: Stéphane Faroult [mailto:sfaroult_at_roughsea.com] Sent: Monday, August 10, 2015 1:47 PM
To: ecandrietta_at_gmail.com; ORACLE-L
Subject: Re: Compare data between 2 tables (same columns) in different schemas

 

SQL?  This might help you:
http://www.oracle.com/technetwork/issue-archive/2010/10-sep/o15asktom-084959.html

If you have full schemas to compare you can generate a script by querying ALL_TAB_COLUMNS.

HTH Stéphane Faroult

On 10/08/15 18:33, Eriovaldo Andrietta wrote:

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-l

Received on Mon Aug 10 2015 - 19:52:33 CEST