Thursday 17 May 2012

ORA-29953: cannot issue DDL on a domain index partition marked as FAILED

ORA-29953: cannot issue DDL on a domain index partition marked as FAILED

Cause: Tried to issue a DROP or ALTER on a domain index partition in a FAILED state.

Action: do ALTER INDEX REBUILD PARTITION to rebuild the index partition OR ALTER TABLE TRUNCATE PARTITION to mark the index partition as valid.

No comments:

Post a Comment