Then I'd be sorely tempted to dump the data from a to flat file, move to b and sqlload. > -----Original Message----- > From: Srinivas.Kommareddy@xxxxxxxxxx > Sent: 08 March 2004 08:24 > To: oracle-l@xxxxxxxxxxxxx; Srinivas.Kommareddy@xxxxxxxxxx > 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@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 > > ********************************************************************** This email contains information intended for the addressee only. It may be confidential and may be the subject of legal and/or professional privilege. Any dissemination, distribution, copyright or use of this communication without prior permission of the sender is strictly prohibited. ********************************************************************** ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------