RE: query help

  • From: "David Sharples" <dsharples@xxxxxxxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 8 Mar 2004 08:37:47 -0000

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Kommareddy, Srinivas
(MED, Wissen Infotech)
Sent: 08 March 2004 08:25
To: oracle-l@xxxxxxxxxxxxx
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

Other related posts: