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!

Turn Non Unique Index into a Unique Index

sql_coderApr 25 2014 — edited Apr 30 2014

Hello,

Version: 11.2.0.4.0 Enterprise Edition

We got a non unique Index for a primary key constraint. I would like to change that into a unique index. I know you cannot alter the index to change it. Is the only way to disable the primary key, drop the index and enable the constraint again or is there a better solution? It is a 24/7 platform.

sql_colder

This post has been answered by unknown-698157 on Apr 25 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 28 2014

Added on Apr 25 2014

#general-database-discussions

8 comments

14,695 views