Oracle Error ORA-29869: cannot issue ALTER without REBUILD on a domain index marked FAILED

Oracle Error Message

ORA-29869: cannot issue ALTER without REBUILD on a domain index marked FAILED

Reason for the Error

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

Solution

Truncate the table to mark the index as valid OR do ALTER INDEX REBUILD to rebuild the index.