Re: Compare data between 2 tables (same columns) in different schemas
From: Stéphane Faroult <sfaroult_at_roughsea.com>
Date: Mon, 10 Aug 2015 19:46:59 +0200
Message-ID: <55C8E393.9050502_at_roughsea.com>
SQL? This might help you:
http://www.oracle.com/technetwork/issue-archive/2010/10-sep/o15asktom-084959.html
Date: Mon, 10 Aug 2015 19:46:59 +0200
Message-ID: <55C8E393.9050502_at_roughsea.com>
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-lReceived on Mon Aug 10 2015 - 19:46:59 CEST