Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Full-text indexing
Slight addition: you can (and probably should) set up an Oracle job using
DBMS_JOB that will run ctx_ddl.sync_index() regularly. 8i also has ctxsrv
application that does reindexing in background, but it's deprecated and is
no longer available in 9i.
Also note that you should maintain correct file names in the indexed table
by yourself - Oracle Text (aka interMedia Text) is not capable of indexing
a file system directory with automatic file change/add/remove tracking.
You should also call ctx_ddl.optimize_index() regularly to purge old data
and resort actual index data in the index.
-- Vladimir Zakharychev (bob@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. "Thomas Hesse" <thomas.hesse_at_team.xtra.co.nz> wrote in message news:3C7471C6.599019E0_at_team.xtra.co.nz...Received on Thu Feb 21 2002 - 03:39:03 CST
>
> Hi,
>
> the way Intermedia Text works is:
>
> 1. create a table and insert data (varchar2, CLOB, BLOB, BFILE,
> filename, url)
> 2. build an intermedia text on it
> 3. now you can search with select ... where contains (index, 'token
> ....')>0;
>
> Only deleted documents are deleted in the index.
> For all other changes (insert,update) in the table you have to manually
> 'sync' your index with
> exec ctx_sync.index (index);
>
> This command reindex all the changed documents.
> You cannot index just a part of a document, always the whole.
>
> See technet.oracle.com -> products -> Oracle Text -> 8.1.5 to 8.1.7 doc
> for docu and samples.
>
> If possible use 8.1.7 for this.
>
> Have fun
> Thomas