Re: Intermedia search fails on new records

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:32:02 CET