Oracle Error ORA-14517: subpartition of index ‘string.string’ is in unusable state

Oracle Error Message

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

Reason for the Error

An attempt has been made to access an index subpartition that has been marked unusable by a direct load or by a DDL operation

Solution

REBUILD the unusable index subpartition