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

EXP-00042: Missing NLS_CHARACTERSET/NLS_NCHAR_CHARACTERSET in props$

1 Answers  


SQL-02132: Unable to allocate runtime context sdfla asdjklfajs jfja ajsdf

1 Answers  


ORA-02191: correct syntax is: SET TRANSACTION USE ROLLBACK SEGMENT <rbs>

1 Answers  


PLS-01704: The expressions in a sort clause must be column specs or unsigned integers, with optional ASC or DESC

1 Answers  


ORA-14194: only one subpartition may be rebuilt

1 Answers  






ORA-38463: invalid XML Tag list

1 Answers  


PLS-00647: attribute by name "string" conflicts with method by same name

1 Answers  


ORA-16636: the object is permanently disabled

1 Answers  


ORA-06568: obsolete ICD procedure called

1 Answers  


ORA-30000: missing either trim specification or char expression in TRIM

1 Answers  


ORA-00369: Current log of thread string not useable and other log being cleared

1 Answers  


ORA-14313: Value string does not exist in partition string

1 Answers  


Categories