ORA-14517: Subpartition of index "string.string" is in unusable state

今天碰到个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.