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

Why can't you delete duplicate rows without a primary key?

Sandeep

On 10/19/05, A Joshi <ajoshi977_at_yahoo.com> wrote:
> 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