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.

No comments:

Post a Comment