Oracle DB Error ORA-26029 index string.string partition string initially in unusable state

The following is the cause of this error:

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 you can take to resolve this issue: Either rebuild index partition, re-create the index, or use either SKIP_UNUSABLE_INDEXES or SKIP_INDEX_MAINTENANCE (SQL*Loader only).

Tags: Database, Microsoft, Oracle, SQL, Software, DBMS, Error Messages, Directory

Related