Re: ** anyway to create a primary key on table with duplicates that cannot be deleted
- From: Sandeep Dubey <dubey.sandeep@xxxxxxxxx>
- To: ajoshi977@xxxxxxxxx
- Date: Wed, 19 Oct 2005 14:54:58 -0400
Why can't you delete duplicate rows without a primary key?
Sandeep
On 10/19/05, A Joshi <ajoshi977@xxxxxxxxx> 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.
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
