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 );
.....