Forum OpenACS Q&A: Re: SWS CR indexing stoped working - max number of extents reached in table

Collapse
8: Re: SWS CR indexing stoped working - max number of extents reached in table (response to 1)
Posted by Jay Dubanik on 02/10/04 05:31 PM
Finally to solve this 
Error: ora8.c:3930:ora_tcl_command: error in`OCIStmtExecute ()':
 ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE
ORA-06512: at "MYUSER.ACS_CONTENTS_SWS_UTR", line 6
problem with Failed index, did some investigation:

There is no index marked as INVALID or Loading
Checked Acs_contents_sws_utr trigger,
Noticed that sws depends on sws_srch_cts_ds_iidx index.
Index is marked as valid but its field: DOMIDX_OPTSTATUS is marked as FAILED


Droped and recreated sws_srch_cts_ds_iidx index
Problem solved

SWS search with Intermedia works, but why is so slow? it takes around 2 minutes to complete a search! ( already done analyze with dbms_stats.gather_schema_stats..)
Is this normal? I hope not.