Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ** anyway to create a primary key on table with duplicates that cannot be deleted
Sorry, ignore my last post. I missed the part where duplicate rows can't
be deleted because table is under replication.
De : oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_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..
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 19 2005 - 16:39:22 CDT