ORA-29861
Domain index index_schema.index_name is marked index_status and currently not usable.
- index_schema: The schema of the domain index.
- index_name: The name of the domain index.
- index_status: The status of the domain index (that is, LOADING, FAILED or UNUSABLE).
Cause
An attempt was been made to access a domain index that was being built or was marked failed by an unsuccessful data definition language (DDL) or was marked unusable by a DDL operation.
Action
Wait for the index build to finish if the specified index is marked LOADING. Drop or rebuild the specified index if it is marked FAILED. Drop or rebuild the specified index if it is marked UNUSABLE.
ORA-29861
domain index is marked LOADING/FAILED/UNUSABLE
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.
ORA-29861
domain index is marked LOADING/FAILED/UNUSABLE
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.