Wednesday, 16 May 2012

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

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

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

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

No comments:

Post a Comment