Oracle Solution for Error ora-29864

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

What triggered the Error:

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

What should we do to fix it:

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.