Skip to Main Content

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!

Unique constraint violation

ProhanJul 1 2010 — edited Jul 1 2010
I just received a unique constraint violation error message when I tried to insert a row into a table.
But even after I deleted the PK constraint on the table in question, I still get the same error message when I retry the insert:
SQL Error: ORA-00001: unique constraint (GILLNET_TAG.DELETED_AUTH_PK) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.

Can somebody tell me why? Is the constraint deletion simply not registering with SQL Developer?
Thanks.
This post has been answered by SomeoneElse on Jul 1 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 29 2010
Added on Jul 1 2010
8 comments
7,925 views