ORA-14517: Subpartition of index "string.string" is in unusable state
来源:互联网 发布:mysql offset查询优化 编辑:程序博客网 时间:2024/05/11 11:01
今天碰到个ORA-03113, 原因不明. 猜测因为某些table DDL操作过后导致index unuable的case, 然后进行analyze table, 再碰到ORA-14517. 最后通过rebuild index subpartition解决.
ORA-03113: end-of-file on communication channel
Cause: The connection between Client and Server process was broken.
Action: There was a communication error that requires further investigation.
==============================================================================================
Oracle Error: ORA-14517
Error Description:
Subpartition of index "string.string" is in unusable state
Error Cause:
An attempt has been made to access an index subpartition that has been marked unusable by a direct load or by a DDL operation.
Action:
REBUILD the unusable index subpartition.
- ORA-14517: Subpartition of index "string.string" 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 ...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-01502 Index state unusable
- ORA-19815: WARNING: string of string bytes is string%% used, and has string remaining bytes available.
- 解决ORA-01502 state unusable错误成因
- Is the Improvement of String.substring() in Java7 Really Reasonable?
- ORA-01502 state unusable错误成因和解决方法(一)
- ORA-01502 state unusable错误成因和解决方法(二)
- String index out of range: -1
- String index out of range: -1
- Hibernate String index out of 0
- Java String index out of range: -1
- 可能会告别每天编码的时光了
- Robotium_客户端登录注销代码(1)
- 想当乔布斯?教你百万元创立智能硬件公司
- CCScrollView使用方法
- qualcomm msm8974ab bring up kernel log
- ORA-14517: Subpartition of index "string.string" is in unusable state
- 一个简单的tab标签页,纯css+js写的,带样式
- 我读经典(3):《大数据时代》学习笔记
- 更改Linux中文件(夹)所属的用户及组
- VC中创建多个线程的方法
- Unrecognized Windows Sockets error: 0: JVM_Bind 异常解决办法
- 一个故事告诉你比特币的原理及运作机制
- postfix安装与配置
- Perl笔记:Perl语言入门(第六版) - 智能匹配、given-when