Adding primary constraint on a table if you have duplicated records already .

[sanQUEST]

hi,

can anybody can tell me how to add pry constraint to a table if it has already duplicated records ? san

[debasisdas]

try to add a NOVALIDATE constraint.

[amitpatel66]

But why you need to do that? A primay key with duplicates??

[sanQUEST]

hi,

thanks , but can you tell me : if we have to use it in 'alter table statement' or any other way ?

san

[Dilip1983]

You can disable the constraint by using alter table statement.

Then insert records into it.

But if there will be duplicate records you won't be able to create a Primary Key on that column.