Disable an Index

Disable an Index example

To disable an oracle database index you must use the command alter index with unusable keyword. The status of index will change from valid to unusable.

  

-- disable Index using UNUSABLE
ALTER INDEX STU_LN_IDX UNUSABLE;
	 

Output:

index STU_LN_IDX altered.

Check indexes

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

Output:

INDEX_NAMEINDEX_TYPESTATUS
STUDENT_IDXNORMALVALID
STU_LN_IDXNORMALUNUSABLE