Oracle Database Discussions

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!

ORA-02443 & ORA-00955

995830Mar 9 2013 — edited Mar 9 2013

Hello guy;

I have a table with a unique constraint which should be made of three keys but made of one key. I decided to drop it and re-create it with the three keys but I got a message saying that says "ORA-02443: Cannot drop constraint - nonexistence constraint". And whenever I try to recreate that constraint with the same name, I get "ORA-00955: name already used bu an existing object."

What do I need to do because I am frustrated with this controversial error message?

Plz help.

This post has been answered by Solomon Yakobson on Mar 9 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 6 2013

Added on Mar 9 2013

#11g, #general-database-discussions

3 comments

2,469 views