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!

Disable unique key constraint

448225Sep 17 2009 — edited Sep 18 2009
Hi,

Is it possible to disable a unique key constraint?
I've tried following code:

ALTER TABLE table_name
DISABLE CONSTRAINT uk_constraint_name

which seems to work fine, but when I try to insert or update a record the unique constraint is still on. However in Toad the UK is marked as disabled.

Do I have to drop the UK and recreate it after my updates?

Thanks
This post has been answered by Hemant K Chitale on Sep 18 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 16 2009
Added on Sep 17 2009
13 comments
22,045 views