ORA-01502 index 'string.string' or partition of such index is in unusable state
Cause 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.
Action DROP the specified index, or REBUILD the specified index, or REBUILD the unusable index partition.