ORA-20000:index is in unusable

上午在进行例行数据库检查时，发现如下报错信息：
Mon Jul 07 22:00:56 2014
GATHER_STATS_JOB encountered errors.  Check the trace file.
Errors in file /u01/app/oracle/diag/rdbms/uniora/uniora/trace/uniora_j002_29328.trc:
ORA-20000: index "HJZXMBGGMT"."INDEX_BUSI_ADVICE_FORM_ID"  or partition of such index is in unusable state

查看索引的状态：
SQL> select owner,index_name,index_type,table_owner,table_name,tablespace_name,
  2  status,last_analyzed from dba_indexes where status='UNUSABLE';


OWNER                          INDEX_NAME
------------------------------ ------------------------------
INDEX_TYPE                  TABLE_OWNER
--------------------------- ------------------------------
TABLE_NAME
------------------------------
TABLESPACE_NAME
--------------------------------------------------------------------------------
STATUS   LAST_ANALYZED
-------- ------------------
HJZXMBGGMT                     INDEX_BUSI_ADVICE_FORM_ID
NORMAL                      HJZXMBGGMT
CC_BUSI_ADVICE


OWNER                          INDEX_NAME
------------------------------ ------------------------------
INDEX_TYPE                  TABLE_OWNER
--------------------------- ------------------------------
TABLE_NAME
------------------------------
TABLESPACE_NAME
--------------------------------------------------------------------------------
STATUS   LAST_ANALYZED
-------- ------------------
HJZX
UNUSABLE 03-SEP-13

重建索引：
SQL> alter index HJZXMBGGMT.INDEX_BUSI_ADVICE_FORM_ID rebuild;


Index altered.


SQL> alter index HJZXMBGGMT.CC_BUSI_FORM_PIID rebuild;


Index altered.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22969361/viewspace-1212304/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22969361/viewspace-1212304/