I am using Oracle 10.2.0.3 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,