Showing posts with label Unique constraint and index relationship. Show all posts
Showing posts with label Unique constraint and index relationship. Show all posts

Thursday, 22 March 2012

Unique constraint and index relationship in Oracle

Dropping Unique Key does not drop the index created for it in Oracle.

I am not very sure for which all versions it happens.

But when I explicitly run the

Drop Index <indexName>;

After execution the same , my unique constraint violation exception issue is fixed.