RE: query help

From: David Sharples <dsharples_at_cerebrussolutions.com>
Date: Mon, 8 Mar 2004 08:37:47 -0000
Message-ID: <EA29A3FCC723674293FD6286D3F0513E572542@louis.cerebrus.com>

Disable the constraint, load the data in, see which row has two values for the same primary key column, remove it then enable the constraint

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kommareddy, Srinivas
(MED, Wissen Infotech)
Sent: 08 March 2004 08:25
To: oracle-l_at_freelists.org
Subject: RE: query help

It's a bit tough.

2 db's are on 2 different servers

and they are prod DBs.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dilip Chavan
Sent: Monday, March 08, 2004 1:38 PM
To: oracle-l_at_freelists.org
Subject: RE: query help

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:33:48 CST