ORA-20000: index " "." " or partition of such index is in unusable state
来源:互联网 发布:nginx与apache解析php 编辑:程序博客网 时间:2024/05/18 03:40
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 );
.....
- ORA-20000: index " "." " or partition of such index is in unusable state
- ORA-20000: index " "." " or partition of such index is in unusable state
- ORA-20000 index ...or partition of such index is in unusable state
- ORA-20000: index "FCSASUSER"."IDX_DN_TREE_ID" or partition of such index is in unusable state
- OGG-00665 (status = 1502-ORA-01502: index 'index' or partition of such index is in unusable state)
- 分析和解决 ORA-01502: index '某分区表索引名' or partition of such index is in unusable state
- 索引错误 index VHL_V6.PK_WEB_APP_TGT_OBJ or partition of such index is in unusable state 的解决办法
- ORA-14517: Subpartition of index "string.string" is in unusable state
- 今天移动表到另一个表空间出现 :ORA-01502 Index state unusable
- unusable index and invisible index 的区别
- INDEX UNUSABLE--〉重建索引
- index invisible与unusable 特性
- Oracle_create an index using unusable
- Is index important in addView()?
- Index or Not Index
- ORA-08104: this index object 115225 is being online built or rebuilt
- ORA-08104: this index object 67420 is being online built or rebuilt
- ORA-08104: this index object xxxxx is being online built or rebuilt
- Tomcat 使用 c3p0连接池
- arm的5级流水线的学习笔记
- 线程常见笔试题
- Symbian快速签名流程详解
- LINUX下ncursor库程序找不到term
- ORA-20000: index " "." " or partition of such index is in unusable state
- ORA-20000: index " "." " or partition of such index is in unusable state
- 【原创】PowerBuilder中的多线程
- 利用反射模拟框架 类加载器 加载配置文件
- JQuery 笔记 js收藏
- 动态生成表格的方法
- 构造函数初始化问题
- 经典书籍
- u-boot-2011.03在TQ2440上的移植(8)--支持下载yaffs2文件系统