RE: query help
- From: "Kommareddy, Srinivas (MED, Wissen Infotech)" <Srinivas.Kommareddy@xxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 8 Mar 2004 02:24:59 -0600
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
Other related posts:
