This statement allows you to rename an index in the current schema. Users cannot rename indexes in the SYS schema.
RENAME INDEX index-Name TO new-index-Name
RENAME INDEX DESTINDEX TO ARRIVALINDEX
RENAME INDEX is not allowed if there are any open cursors that reference the index being renamed.