Sentinel: ORA-01502

  • Document ID:3725510
  • Creation Date:02-Nov-2006
  • Modified Date:26-Apr-2012
    • Micro Focus Products:
      Sentinel

Environment

Oracle 9.2.0.6
Sentinel 5.1.x

Situation

Oracle error ORA-01502

Resolution

The error ORA-01502 means that an index; or partition of such index is in an unusable state

The 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