ORA-01502 index state unusable錯誤成因和解決方法

arthurtangel發表於2012-05-30
ORA-01502 index 'string.string' or partition of such index is in unusable state
CauseAn 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.
ActionDROP 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;

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/11990065/viewspace-731459/,如需轉載,請註明出處,否則將追究法律責任。

相關文章