Question: How do I rename an
index? Is there an overhead in renaming an index?
Answer: The alter index
command allows you to rename an index using the rename the
index to keyword as seen in this example:
In this case we have renamed the ix_emp_01 index to
ix_emp_01_old. All of the data dictionary entries will be
changed by Oracle to reflect the new name.
The alter index rename operations only updates
the data dictionary, so the command executes quickly and
causes minimal locking, perfect for online operations.