Re: keep intermedia index up-to-date

You can either use ctxsrv or use dbms_job to schedule 'resync index'. There is a package called 'ctx_schedule' to help do the latter - search on metalink.
ctxsrv would a process that runs as an NT service if you are on NT or as a background process.
This is what we currently use, but it is not the recommended technique. I have more details if you need them.

Tim

"Martin Koeck" <nospam_at_nospam.at> wrote in message news:3ACB41FB.3C349E75_at_nospam.at...
> we use an intermedia index to index a CLOB column and be able to
> search it via SELECT ... CONTAINS, which seems to work so far
>
> it seems that rows
> - can be inserted/updated but changes are NOT reflected in the index
> - cannot be deleted (query "hangs")
>
> so what to do to keep the index "automatically" up-to-date ?
>
> something like "alter index ... rebuild" on a trigger does not
> work because this implies a commit which is not allowed in a trigger
>
> thanks for any comments on this,
> martin
Received on Fri Apr 06 2001 - 07:04:27 CDT