From oracle-l-bounce@freelists.org Wed Oct 19 16:40:12 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9JLdv3G002292 for ; Wed, 19 Oct 2005 16:40:02 -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 j9JLdqvX002270 for ; Wed, 19 Oct 2005 16:39:52 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9322B20909D; Wed, 19 Oct 2005 16:39:41 -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 03009-10; Wed, 19 Oct 2005 16:39:41 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E29F92091C0; Wed, 19 Oct 2005 16:39:40 -0500 (EST) From: "Mark W. Farnham" To: , Subject: RE: ** anyway to create a primary key on table with duplicates that cannot be deleted Date: Wed, 19 Oct 2005 17:36:00 -0400 Message-ID: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_003A_01C5D4D3.9263D010" X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 In-Reply-To: <20051019175811.44385.qmail@web60712.mail.yahoo.com> X-archive-position: 27226 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mwf@rsiz.com Precedence: normal Reply-To: mwf@rsiz.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=-3.6 required=5.0 tests=AWL,BAYES_00, HTML_FONTCOLOR_BLUE,HTML_MESSAGE autolearn=no version=2.63 ------=_NextPart_000_003A_01C5D4D3.9263D010 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit add a column as rownum or some other unique value. unfortunately the whole thing will replicate, but you should be able to add the pk. www.rsiz.com Oracle Technology and Business Consulting Mark W. Farnham President Rightsizing, Inc. 36 West Street Lebanon, NH 03766-1239 mwf@rsiz.com tel: (603) 448-1803 Want a signature like this? -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of A Joshi Sent: Wednesday, October 19, 2005 1:58 PM To: oracle-l@freelists.org Subject: ** anyway to create a primary key on table with duplicates that cannot be deleted Hi, 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.. 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. ---------------------------------------------------------------------------- -- Yahoo! Music Unlimited - Access over 1 million songs. Try it free. ------=_NextPart_000_003A_01C5D4D3.9263D010 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
add a=20 column as rownum or some other unique value. unfortunately the whole = thing will=20 replicate, but you should be able to add the pk.
 
www.rsiz.com Oracle Technology and Business=20 Consulting
Mark W. = Farnham
President=20 		Rightsizing, Inc.
36 West Street
Lebanon, NH=20 03766-1239
mwf@rsiz.com
tel: = (603) 448-1803=20 =
Want a=20 signature like = this?
-----Original Message-----
From:=20 oracle-l-bounce@freelists.org = [mailto:oracle-l-bounce@freelists.org]On=20 Behalf Of A Joshi
Sent: Wednesday, October 19, 2005 1:58 = PM
To: oracle-l@freelists.org
Subject: ** anyway = to create=20 a primary key on table with duplicates that cannot be=20 deleted

Hi,
   I have a table under replication and corrupted with=20 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=20 and cannot quiese right now due to processing that will last another 4 = days.=20 Thanks for help.

Yahoo!=20 Music Unlimited - Access over 1 million songs. Try it=20 free.
------=_NextPart_000_003A_01C5D4D3.9263D010-- -- http://www.freelists.org/webpage/oracle-l