Oracle DBA, How To, Error, Cause and Action

ORA-01502: index 'string.string' or partition of such index is inunusable state

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