Sentinel: ORA-01502

  • 3725510
  • 02-Nov-2006
  • 26-Apr-2012

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