RENAME INDEX statement

RENAME INDEX statement The RENAME INDEX statement renames an index in the current schema, which can be any schema except the schema SYS. RENAME INDEX statement Syntax RENAME INDEX indexName TO newIndexName Example RENAME INDEX DESTINDEX TO ARRIVALINDEX

Statement dependency system

RENAME INDEX is not allowed if there are any open cursors that reference the index being renamed.