Re: Full-text indexing

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 Received on Wed Feb 20 2002 - 22:04:22 CST