ORA-14517: subpartition of index 'string.string' is in
unusable state



ORA-14517: subpartition of index 'string.string' is in unusable state..

Answer / guest

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

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-36640: (XSDUNION19) Concat dimension workspace object cannot be changed to UNIQUE because base dimension workspace object does not have a TEXT or ID datatype.

1 Answers  


LFI-00138: Unable to perform string on a name object that is string.

1 Answers  


ORA-16059: Log file is empty or invalid next available block

1 Answers  


TNS-04008: %-25s | string

1 Answers  


ORA-39111: Dependent object type string skipped, base object type string already exists

1 Answers  


ORA-30186: '' must be followed by four hexdecimal characters or another ''

1 Answers  


DRG-10599: column is not indexed

1 Answers  


ORA-29376: number of consumer groups string in top-plan string exceeds string

1 Answers  


ORA-29701: unable to connect to Cluster Manager

1 Answers  


ORA-19902: incarnation key string not found

1 Answers  


PCC-02133: CMD-LINE: Error in string processing function

1 Answers  


PLS-00308: this construct is not allowed as the origin of an assignment

1 Answers  


Categories