Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Constraint violated

Chanchal WankhadeSep 21 2012 — edited Sep 21 2012
Hi All,

I have oracle 10g R2 on windows.

One of my table is having primary key constraint on 6 column. its working fine.

My issue is :-

1) I drop the primary key constraint. Now I am trying to create it again but it's not allowing me to create the primary key constraint again on the same columns. While checking dumplicate records i found some duplicate records.

Before I droped the constraint it was working fine that means it doesnot have any dupplicate values. but after droping the constraint and trying to create it again, suddenly its showing dupplicate values. No insert or Update made. Why?
This post has been answered by Purvesh K on Sep 21 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 19 2012
Added on Sep 21 2012
6 comments
528 views