From oracle-l-bounce@freelists.org Wed Oct 19 13:02:09 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9JI28kr001789 for ; Wed, 19 Oct 2005 13:02:08 -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 j9JI23vX001762 for ; Wed, 19 Oct 2005 13:02:03 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F03F22092F7; Wed, 19 Oct 2005 13:00: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 05394-06; Wed, 19 Oct 2005 13:00:41 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 628C220937E; Wed, 19 Oct 2005 13:00:41 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=nIagvBrIgqkS3q1fxTV5Etv0Ea+0SZ/mkyCubyMWMDJSVOATFJArXtJuNueqC6Hyj77xDumatUtUlzucXXt8tyG6kxKA4adGA75tRfNPpur4CSbcQIUBwsO1AIgucv84efvGkFbMnxG3i3YKV+sPFqE1geMbb/4Ch0Mpr3b75ow= ; Message-ID: <20051019175811.44385.qmail@web60712.mail.yahoo.com> Date: Wed, 19 Oct 2005 10:58:11 -0700 (PDT) From: A Joshi Subject: ** anyway to create a primary key on table with duplicates that cannot be deleted To: oracle-l@freelists.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1332530998-1129744691=:44286" X-archive-position: 27214 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ajoshi977@yahoo.com Precedence: normal Reply-To: ajoshi977@yahoo.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=-1.5 required=5.0 tests=AWL,BAYES_00, FORGED_YAHOO_RCVD,FROM_ENDS_IN_NUMS,HTML_MESSAGE autolearn=no version=2.63 --0-1332530998-1129744691=:44286 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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. --0-1332530998-1129744691=:44286 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
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. --0-1332530998-1129744691=:44286-- -- http://www.freelists.org/webpage/oracle-l