It's a bit tough. 2 db's are on 2 different servers and they are prod DBs. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Dilip Chavan Sent: Monday, March 08, 2004 1:38 PM To: oracle-l@xxxxxxxxxxxxx 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Kommareddy, Srinivas (MED, Wissen Infotech) Sent: Monday, March 08, 2004 1:35 PM To: oracle-l@xxxxxxxxxxxxx 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