Showing posts with label ORA-29864: analyzing domain indexes marked LOADING or FAILED not supported. Show all posts
Showing posts with label ORA-29864: analyzing domain indexes marked LOADING or FAILED not supported. Show all posts

Wednesday, 16 May 2012

ORA-29864: analyzing domain indexes marked LOADING or FAILED not supported

ORA-29864: analyzing domain indexes marked LOADING or FAILED not supported

Cause: Tried to analyze a domain index which was marked as LOADING or FAILED.

Action: If the index was marked LOADING, wait till it is marked valid before retrying the analyze. If index was marked FAILED, drop it OR rebuild it and retry the analyze.