RE: ** anyway to create a primary key on table with duplicates that cannot be deleted
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <ajoshi977@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 19 Oct 2005 17:36:00 -0400
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@xxxxxxxx tel: (603) 448-1803
Want a signature like this?
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of A Joshi
Sent: Wednesday, October 19, 2005 1:58 PM
To: oracle-l@xxxxxxxxxxxxx
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.
Other related posts:
