Re: Intermedia search fails on new records

Is there context server running on your machine? (ctxsys/ctxsyspassword | ctxsrv -personality M)

Blazej

Harry wrote:
> Using Oracle 8i (8.1.7.0) on win 2000 (sp3)
>
> Each time I add a new record I have to drop & recreate Intermedia
> index (using statement below, to allow searching on Word 97 Document
> held in 'DOCUMENT' field
>
> CREATE INDEX PUB_INDEX ON NHD_PUBLICATION(DOCUMENT) INDEXTYPE IS
> CTXSYS.CONTEXT
>
> This statement then works fine -
>
> SELECT * FROM NHD_PUBLICATION WHERE CONTAINS (DOCUMENT,
> 'manufacturers')> 0;
>
> If I add a new record with Word doc containing 'accommodation' word it
> fails i.e
>
> SELECT * FROM NHD_PUBLICATION WHERE CONTAINS (DOCUMENT,
> 'accommodation')> 0;
>
> I have to drop/recreate index to make it work!
>
> Surely this should work straight away?
>
> any ideas?
>
> thanks
>
> harry
Received on Fri Nov 15 2002 - 09:23:41 CST