Monday, 30 April 2012

ORA-26027: unique index string.string partition string initially in unusable state

ORA-26027: unique index string.string partition string initially in unusable state

Cause: A partition of a unique index is in IU state (a unique index * cannot have index maintenance skipped via SKIP_UNUSABLE_INDEXES).

Action: Either rebuild the index or index partition, or use * SKIP_INDEX_MAINTENANCE if the client is SQL*Loader.

No comments:

Post a Comment