Rename an Index

Rename Index example

  

-- rename Index 
ALTER INDEX STUDENT_IDX 
  RENAME TO STUDENT_IDX_2;

Output:

index STUDENT_IDX altered.

Check index

select INDEX_NAME, INDEX_TYPE, TABLESPACE_NAME
from USER_INDEXES
WHERE table_name='STUDENTS_LIST';

Output:

INDEX_NAME	INDEX_TYPE	TABLESPACE_NAME
STUDENT_IDX_2	NORMAL	SYSTEM

↑