Re: Intermedia search fails on new records
Date: Fri, 15 Nov 2002 16:42:59 +0100
Message-ID: <3DD51603.7010803_at_klub.chip.pl>
'ctxsrv' is a proces wich is responsible for keeping you index up to
date. So if you change your data the process rebuilds the index for you.
And you will see it as a result of the 'select where conatins >0'
Blazej
Harry wrote:
> Ahh, you've confused me now - how/what/where do I use
> (ctxsys/ctxsyspassword | ctxsrv -personality M)?
>
> Sorry for being a bit of a thicky!
>
> On Fri, 15 Nov 2002 16:23:41 +0100, Blazej Stachowiak
> <mfbk_at_klub.chip.pl> wrote:
>
>
>>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 - 16:42:59 CET