Oracle Error Message
ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE
Reason for the Error
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.
Solution
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.