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-13379: invalid index for sub-element to be extracted

1 Answers  


RMAN-05021: this configuration cannot be changed for a BACKUP or STANDBY control file

1 Answers  


ORA-14175: a subpartition maintenance operation may not be combined with other operations

1 Answers  


ORA-01910: TABLES keyword expected

1 Answers  


NZE-28840: Wallet is already open.

1 Answers  






NZE-29232: the cryptographic engine key initialization failed

1 Answers  


ORA-15000: command disallowed by current instance type

1 Answers  


DRG-10580: parallel indexing is not supported: string

1 Answers  


ORA-15051: file 'string' contains string error(s)

1 Answers  


ORA-26516: no push transaction acknowledgement

1 Answers  


ORA-03129: the next piece to be inserted is required

1 Answers  


PLS-00715: attribute or method by name 'string' does not exist

1 Answers  


Categories