ORA-20000: index " "." " or partition of such index is in unusable state

Errors in file /export/home/oracle/admin/ora10/bdump/ora10_j001_20464.trc:
ORA-20000: index "   "."  "  or partition of such index is in unusable state

 

SQL> select  STATUS,INDEX_NAME  from ind where table_name like 'LOG_%';

STATUS   INDEX_NAME
-------- ------------------------------
UNUSABLE IND_LOGMORSP_MSGID
UNUSABLE IND_LOGMORSP_SERIALID
UNUSABLE IND_LOGMOFRSP_MSGID
许多无效

 

重建索引就可以了.

ALTER INDEX  IND_LOGMORSP_MSGID REBUILD NOCOMPRESS NOPARALLEL TABLESPACE SXITISMG_LOG STORAGE ( INITIAL  64K   );
 .....