Oracle Error Codes

All Oracle Database Error Codes

Oracle database error code ORA-29869 – cannot issue ALTER without REBUILD on a domain index marked FAILED

Oracle Database Error Code ORA-29869 Description :

cannot issue ALTER without REBUILD on a domain index marked FAILED

Error Cause:

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

How to Solve :

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