Oracle Error Codes

All Oracle Database Error Codes

Oracle database error code ORA-29953 – cannot issue DDL on a domain index partition marked as FAILED

Oracle Database Error Code ORA-29953 Description :

cannot issue DDL on a domain index partition marked as FAILED

Error Cause:

Tried to issue a DROP/ALTER on a domain index partition in a FAILED state.

How to Solve :

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