Re: Intermedia search fails on new records
From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Fri, 15 Nov 2002 22:36:38 +0300
Message-ID: <ar3ig8$1is$1_at_babylon.agtel.net>
Date: Fri, 15 Nov 2002 22:36:38 +0300
Message-ID: <ar3ig8$1is$1_at_babylon.agtel.net>
You can setup an Oracle job that will look like this:
for idx in (select pnd_index_name iname from ctx_user_pending)
loop
set it to run at regular intervals and this should do the trick.
Actually, ctxsrv use is deprecated and what it does rougly
matches the job above.
For more information on Oracle jobs and how to set them up,
refer to DBMS_JOB package in Supplied PL/SQL Packages Reference.
CTX_DDL.SYNC_INDEX(idx.iname);
end loop;
-- Vladimir Zakharychev (bob_at_dpsp-yes.com) http://www.dpsp-yes.com Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications. All opinions are mine and do not necessarily go in line with those of my employer. "Harry" <a_at_abc.com> wrote in message news:cn6atuc42clv6nd8986hvka6ke7m80sj59_at_4ax.com...Received on Fri Nov 15 2002 - 20:36:38 CET
> 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
> >>>
> >>
>