ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE



ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE..

Answer / guest

Cause: An attempt has been made to access a domain index
that is being built or is marked failed by an unsuccessful
DDL or is marked unusable by a DDL operation.

Action: Wait if the specified index is marked LOADING Drop
the specified index if it is marked FAILED Drop or rebuild
the specified index if it is marked UNUSABLE.

Please add more information about this Error

Is This Answer Correct ?    3 Yes 3 No

Post New Answer

More Oracle Errors Interview Questions

ORA-33052: (XSAGDNGL25) AGGMAP workspace object is a dimensioned AGGMAP; it can only be used to aggregate like-dimensioned variables.

1 Answers  


PCB-00637: Host variable is not an exact binary integer

1 Answers  


TNS-01410: Service "string" has number instances.

1 Answers  


ORA-12423: invalid position specified

1 Answers  


RMAN-08041: partial resync skipped, controlfile is not current or backup

1 Answers  






PCC-00124: COMMON_NAME option is specified too late

1 Answers  


IMG-00871: unexpected number of seeds

1 Answers  


RMAN-10012: KGU error: string

1 Answers  


ORA-31500: change source string is not a ManualLog change source

1 Answers  


NNC-00429: invalid octet string literal "string"

1 Answers  


NZE-29140: Cannot create certificate object.

1 Answers  


ORA-07449: sc: usnewlock failed.

1 Answers  


Categories