From oracle-l-bounce@freelists.org Mon Mar 8 02:33:48 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i288Xm830082 for ; Mon, 8 Mar 2004 02:33:48 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i288XLo30057 for ; Mon, 8 Mar 2004 02:33:21 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 82BF4394F66; Mon, 8 Mar 2004 03:31:40 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 08 Mar 2004 03:30:35 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from louis.cerebrus.com (unknown [194.202.36.60]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4FC37394F18 for ; Mon, 8 Mar 2004 03:30:31 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.6944.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C404E8.A2AD0615" Subject: RE: query help Date: Mon, 8 Mar 2004 08:37:47 -0000 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: query help Thread-Index: AcQE50+cbat5LYVGS2mZP3Nw+xA41AAATcNg From: "David Sharples" To: X-archive-position: 73 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: dsharples@cerebrussolutions.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------_=_NextPart_001_01C404E8.A2AD0615 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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 =20 ________________________________ From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Kommareddy, Srinivas (MED, Wissen Infotech) Sent: 08 March 2004 08:25 To: oracle-l@freelists.org Subject: RE: query help =20 It's a bit tough.=20 =20 2 db's are on 2 different servers and they are prod DBs. =20 =20 -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Dilip Chavan Sent: Monday, March 08, 2004 1:38 PM To: oracle-l@freelists.org Subject: RE: query help =20 Hi, =20 Try exceptions table. It will give you the rows which are causing the problem. It's quite fast also. =20 ~Dilip =20 =20 =20 -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Kommareddy, Srinivas (MED, Wissen Infotech) Sent: Monday, March 08, 2004 1:35 PM To: oracle-l@freelists.org Subject: query help HI All, =20 I want to perform date load from table A to table B. Its failing with unique constraitn problem. =20 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). =20 (better than a union all) =20 (tables are big they have more than 1 million rows) =20 =20 Tx and Regards, Srinivas ------_=_NextPart_001_01C404E8.A2AD0615 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Kommareddy, Srinivas (MED, Wissen Infotech)
Sent: 08 March 2004 = 08:25
To: oracle-l@freelists.org
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@freelists.org [mailto:oracle-l-bounce@freelists.org] = On Behalf Of Dilip Chavan
Sent: Monday, March 08, 2004 1:38 PM
To: oracle-l@freelists.org
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@freelists.org = [mailto:oracle-l-bounce@freelists.org]On Behalf Of Kommareddy, Srinivas = (MED, Wissen Infotech)
Sent: Monday, March 08, 2004 1:35 PM
To: oracle-l@freelists.org
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

------_=_NextPart_001_01C404E8.A2AD0615-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------