From oracle-l-bounce@freelists.org Wed Oct 19 16:39:22 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9JLd2Xj002160 for ; Wed, 19 Oct 2005 16:39:12 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j9JLcxvX002126 for ; Wed, 19 Oct 2005 16:39:00 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 02EED2087E0; Wed, 19 Oct 2005 16:38:44 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 02799-05; Wed, 19 Oct 2005 16:38:43 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7CFF4208926; Wed, 19 Oct 2005 16:38:43 -0500 (EST) x-mimeole: Produced By Microsoft Exchange V6.0.6603.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5D4F5.322BE490" Subject: RE: ** anyway to create a primary key on table with duplicates that cannot be deleted Date: Wed, 19 Oct 2005 14:36:42 -0700 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: ** anyway to create a primary key on table with duplicates that cannot be deleted Thread-Index: AcXU1zT9N46iD4zHTj6v8SMA5Q5kCAAHd2qw From: "Jacques Kilchoer" To: , X-OriginalArrivalTime: 19 Oct 2005 21:36:42.0785 (UTC) FILETIME=[326A9910:01C5D4F5] X-archive-position: 27225 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Jacques.Kilchoer@quest.com Precedence: normal Reply-To: Jacques.Kilchoer@quest.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-2.7 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------_=_NextPart_001_01C5D4F5.322BE490 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Sorry, ignore my last post. I missed the part where duplicate rows can't be deleted because table is under replication. _____ =20 De : oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] De la part de A Joshi I have a table under replication and corrupted with duplicates. I cannot do any update/delete operation on the table since it needs a primary key. I cannot create a primary key since duplicates exist. catch..=20 i tried creating index by appending rowid/rownum but no luck. Any way out of this. Cannot remove the table from replication since that needs quiescing and cannot quiese right now due to processing that will last another 4 days. Thanks for help.=20 ------_=_NextPart_001_01C5D4F5.322BE490 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Sorry, = ignore my last=20 post. I missed the part where duplicate rows can't be deleted because = table is=20 under replication.

De : = oracle-l-bounce@freelists.org=20 [mailto:oracle-l-bounce@freelists.org] De la part de A=20 Joshi

I have a table under replication and = corrupted=20 with duplicates. I cannot do any update/delete operation on the table = since it=20 needs a primary key. I cannot create a primary key since duplicates = exist.=20 catch..

i tried creating index by appending rowid/rownum but no luck. Any = way out=20 of this. Cannot remove the table from replication since that needs = quiescing and=20 cannot quiese right now due to processing that will last another 4 days. = Thanks=20 for help.

------_=_NextPart_001_01C5D4F5.322BE490-- -- http://www.freelists.org/webpage/oracle-l