Oracle Error Message
ORA-29954: domain index partition 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 partition is marked LOADING Rebuild the specified index partition if it is marked FAILED or UNUSABLE.