Skip to Main Content

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

Comments

bkmcdaniel
Answer
Marked as Answer by 4187794 · Sep 27 2020
InoL

See yesterday's topic (which means if you search before you ask, you will have an answer much quicker):

Oracle Apex Migration(Access to Apex 19.2)

4187794

bkmcdaniel: Thank you for the link!

InoL: I have done a lot of searching. I apologize for not finding that discussion and posting a new thread.

I saw a question on there that I have. Can we stand up an older apex instance to convert applications then migrate those into 19c  - does anyone know how feasible/reliable of an approach this may be?

InoL
Can we stand up an older apex instance to convert applications then migrate those into 19c  -

You can.

However, there is a reason Oracle stopped support: the result was very poor. There is just no way to convert the code to PL/SQL and Javascript automatically. In the end you have to do everything manually anyway.

4187794

Thanks ya, appreciate it.

edit: Even though you have made me sad.

1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 28 2014
Added on Apr 25 2014
8 comments
14,474 views