Re: Intermedia search fails on new records

Oracle recommend using CTX_DLL.SYNC_INDEX via a DBMS_JOB. This is due to a). Fragmentation as outlined by Tim. b). Oracle are depreciating the ctxsvr functionality in later releases.

Cheers,

Greg

"Tim Arnold" <timkarnold_at_comcast.net> wrote in message news:<tK2dneYRZ_IwkkSgXTWcoA_at_comcast.com>...
> "Harry" <a_at_abc.com> wrote in message
> news:ohehtu47vt54417uhgl8cblk576iom20g9_at_4ax.com...
> > Thanks for that also, but I'm using Oracle 8i enterprise so which
> > method should I use?
> >
> > On Fri, 15 Nov 2002 22:36:38 +0300, "Vladimir M. Zakharychev"
> > <bob_at_dpsp-yes.com> wrote:
> >
> > >You can setup an Oracle job that will look like this:
> > >
> > >for idx in (select pnd_index_name iname from ctx_user_pending)
> > > loop
> > > CTX_DDL.SYNC_INDEX(idx.iname);
> > > end 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.
> > >And don't forget to set your job_queue_processes > 0 in init.ora,
> > >or there will be no processes to run your jobs...
> >
>
> Whichever is easier(?)
>
> CTX_DDL.SYNC_INDEX is the preferred method.
> We use ctxsrv because it is instantaneous. The downside is a) deprecated b)
> there is claim of index fragmentation. We wrote an NT service wrapper for
> ctxsrv, so it comes up as service and no need for a dedicated workstation.
>
> Regards,
> Tim
Received on Tue Nov 19 2002 - 05:46:19 CET