Database Error Messages

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

ORA-26029

index string.string partition string initially in unusable state

Cause

A partition of an index is in IU state prior to the beginning of a direct path load, it cannot be maintained by the loader.


Action

Either rebuild index partition, re-create the index, or use either SKIP_UNUSABLE_INDEXES or SKIP_INDEX_MAINTENANCE (Sql*Loader only).