partition index unusable

 

ORA-01502 index 'string.string' or partition of such index is in unusable state

Cause	An attempt has been made to access an index or index partition that has been marked unusable by a direct load or by a DDL operation.
Action	DROP the specified index, or REBUILD the specified index, or REBUILD the unusable index partition.

--query which partition index is unusable. then rebuild it.

select * from dba_ind_partitions where index_name='IDX_BAR_QST_PROD_TEST_TIME' where status <> 'USABLE'

alter index OCR_DB.IDX_BAR_QST_PROD_TEST_TIME rebuild partition PART_BAR_QST_2_3;