Re: Error while rebuilding a text index

From: joel garry <>
Date: Thu, 10 Dec 2009 10:18:10 -0800 (PST)
Message-ID: <>

On Dec 9, 8:23 pm, zigzagdna <> wrote:
> I am using Oracle on HP UNIX 11i. I am rebuilding a text
> index (textidx1) online
> using:
> Alter index rebuild textidx1;
> If I do a query so index is used, I get:
> ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE
> Error goes away after index is completely rebuilt.
> Since I am rebuilding index online, this error should not occur,
> otherwise what
> Is the purpose of on line index rebuild? Can someone explain how to
> get rid
> o the error. I cannot  stop my application while rebuilding text
> indexes.

I learn something new every day:

"This will de-fragment the $X index for fastest access. If you want to be able to continue to run queries while this is happening, you should append the ONLINE keyword. "

Sometimes I learn strange things.


-- is bogus.
Received on Thu Dec 10 2009 - 12:18:10 CST

Original text of this message