RE: query help

From: Dilip Chavan <dilipc_at_gtllimited.com>
Date: Mon, 8 Mar 2004 13:37:53 +0530
Message-ID: <NHBBLLPKEJDEHLFEJLJPIEGACCAA.dilipc@gtllimited.com>

Hi,

Try exceptions table. It will give you the rows which are causing the problem.
It's quite fast also.

~Dilip

  -----Original Message-----
  From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Kommareddy, Srinivas (MED, Wissen Infotech)
  Sent: Monday, March 08, 2004 1:35 PM
  To: oracle-l_at_freelists.org
  Subject: query help

HI All,

I want to perform date load from table A to table B. Its failing with unique constraitn problem.

Could someone post me to find out the rows that are already existing in TABLE B (target table) (which are in table A i.e. source table).

(better than a union all)

(tables are big they have more than 1 million rows)

Tx and Regards,

Srinivas

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Mar 08 2004 - 02:09:58 CST