Showing posts with label ORA-29861: domain index is marked LOADING or FAILED or UNUSABLE. Show all posts
Showing posts with label ORA-29861: domain index is marked LOADING or FAILED or UNUSABLE. Show all posts

Wednesday, 16 May 2012

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

ORA-29861: domain index is marked LOADING or FAILED or 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.