RE: ** anyway to create a primary key on table with duplicates that cannot be deleted

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Wed, 19 Oct 2005 17:36:00 -0400
Message-ID: <KNEIIDHFLNJDHOOCFCDKAEADHCAA.mwf@rsiz.com>

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_at_rsiz.com  tel:  (603) 448-1803




            Want a signature like this?

  -----Original Message-----
  From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of A Joshi   Sent: Wednesday, October 19, 2005 1:58 PM   To: oracle-l_at_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.

--

http://www.freelists.org/webpage/oracle-l Received on Wed Oct 19 2005 - 16:40:12 CDT