You can rename an index in a base table or global temporary table with the owner type USER. See ALTER INDEX statement in Reference: Statements and Options for more information on renaming indexes and changing foreign key role names. Note that indexes created to enforce key constraints cannot be renamed.