Oracle Solution for Error ora-29869
ORA-29869: cannot issue ALTER without REBUILD on a domain index marked FAILED
What triggered the Error:
Tried to issue a DROP/ALTER on a domain index in a FAILED state.What should we do to fix it:
Truncate the table to mark the index as valid OR do ALTER INDEX REBUILD to rebuild the index.
If this was not sufficient go over to:
Oracle Official Support Knowledge Center
Or maybe those geeks at: StackOverflow Board
Or maybe those geeks at: StackOverflow Board
