Re: Intermedia search fails on new records

Thanks for that mate, from the DOS prompt I tried

ctxsrv.exe -user ctxsys/ctxsys

& it works

Do you know of a way within Oracle to specfy this to automatically start up when Oracle starts or do I have to run the command manually?

thanks

harry

On Fri, 15 Nov 2002 16:42:59 +0100, Blazej Stachowiak <mfbk_at_klub.chip.pl> wrote:

>'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 - 10:05:24 CST