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_NAMEINDEX_TYPETABLESPACE_NAME
STUDENT_IDX_2NORMALSYSTEM