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..

Answer / guest

Cause: Tried to issue a DROP/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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

QSM-02141: the reason why the capability is disabled has escaped analysis

1 Answers  


ORA-22810: cannot modify object attributes with REF dereferencing

1 Answers  


IMG-00924: Incorrect parameter specification during CREATE INDEX

1 Answers  


ORA-02306: cannot create a type that already has valid dependent(s)

1 Answers  


ORA-14301: table-level attributes must be specified before partition-level attributes

1 Answers  






ORA-36810: (XSTBLFUNC05) Analytic workspace object number does not exist.

1 Answers  


CLSR-00501: Error number encountered when connecting to EVM daemon

1 Answers  


ORA-29878: warning in the execution of ODCIINDEXTRUNCATE routine

1 Answers  


PLS-00130: Pragma string expects 1st argument to be a procedure/function/package/cursor

1 Answers  


ORA-06536: IN bind variable bound to an OUT position

1 Answers  


LPX-00662: Invalid encoding.

1 Answers  


ORA-07623: smscre: $CRMPSC failure

1 Answers  


Categories