Oracle database error code ORA-01502 – index string.string or partition of such index is in unusable state

Oracle Database Error Code ORA-1502 Description :
index string.string or partition of such index is in unusable state
Error 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

How to Solve :
DROP the specified index, or REBUILD the specified index, or REBUILD the unusable index partition


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , , , ,
1 Comment   
«
»