Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

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