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

Oracle Error Message

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

Reason for the Error

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

Solution

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