ORA-01502 index 'string.string' or partition of such index is in unusable state
Oracle Database Error Code Messages ORA-01502 Help About Description;
Index 'string.string' or partition of such index is in unusable state.
Cause for Error and Problem;
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.
How to Solve;ORA-01502 index 'string.string' or partition of such index is in unusable state?
Action for Solve and Fix Ora-01502;
DROP the specified index, or REBUILD the specified index, or REBUILD the unusable index partition.
Next Post Ora-02102;
