RE: query help
- From: "Dilip Chavan" <dilipc@xxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 8 Mar 2004 13:37:53 +0530
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
- References:
- query help
- From: Kommareddy, Srinivas (MED, Wissen Infotech)
Other related posts:
