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