Skip to Main Content

SQL Developer Data Modeler

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!

Rename constrain name or index name.

695262Mar 14 2012 — edited Mar 14 2012
When you change an index name, or a constrain name, and then, you want to sincronize the relational model with the data dictionary, the generated DLL(delta),
use drop index, and create index.
This will not work in certain scenarios like unique index name, due to the fact that you can not delete unique index.

It is posible that instead of making drop create index, just make a rename statement?
Thanks in advance.

IEg:
INSTEAD OF:

DROP INDEX schema_name.index_name
;
CREATE UNIQUE INDEX shcema_name.new_index_name ON schema_name.table_name

DO:

ALTER TABLE schema_name.table_name
RENAME CONSTRAINT schema_name.index_name
TO shcema_name.new_index_name;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 11 2012
Added on Mar 14 2012
1 comment
438 views