ORA-20000
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 );
.....
本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/shuchangjun/archive/2011/03/21/6265010.aspx
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11763200/viewspace-690361/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- [PRKC-1002
- PRKC-1044 :
- CRS-0184: Cannot communicate with the CRS daemon.
- PRKP-1001 : CRS-0215:
- The directory is not on cluster file system partition shared across nodes
- error while loading shared libraries: libpthread.so.0:
- Startup will be queued to init within 90 seconds
- ORA-00600
- delete obsolete 下的错误
- 数据库安装出现乱码
