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

  • From: Stéphane Faroult <sfaroult@xxxxxxxxxxxx>
  • To: ecandrietta@xxxxxxxxx, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 10 Aug 2015 19:46:59 +0200

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


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 08-2015