8 Replies Latest reply on Apr 30, 2014 10:12 AM by sql_coder

    Turn Non Unique Index into a Unique Index

    sql_coder

      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