Re: ** anyway to create a primary key on table with duplicates that cannot be deleted
- From: Lou Fangxin <anysql@xxxxxxxxx>
- To: ajoshi977@xxxxxxxxx
- Date: Fri, 21 Oct 2005 13:19:10 +0800
Hi all:
Create a non-unique index, then add the primary key constraint with
"enable novalidate" option, it will keep the new rows inserted unique, while
keep the current duplicate rows exist in table.
On 10/20/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.<http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=36035/*http://music.yahoo.com/unlimited/>
>
>
--
Welcome, Fangxin.Lou from China
Home: http://www.anysql.net/en/
Mydul: http://www.anysql.net/en/mydmp.html
Other related posts:
