Oracle Error ORA-01502: index ‘string.string’ or partition of such index is in unusable state

Oracle Error Message

ORA-01502: index ‘string.string’ or partition of such index is in unusable state

Reason for the Error

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

Solution

DROP the specified index, or REBUILD the specified index, or REBUILD the unusable index partition