Intermedia search fails on new records

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:00:41 CET