Re: Incremental indexing in Oracle Text

Thanks for the help! The sync_index procedure sounds like it's going to be my friend.

Russell.

John Russell wrote:
>
> The way to update only the changed rows in the index is the PL/SQL
> procedure CTX_DDL.SYNC_INDEX('<index_name>'). I use a FILE_DATASTORE
> where the primary key of my table holds the names of the files with
> the text. If I need to just replace part of the index, I'll do
>
> update <table> set <indexed_column> = <indexed_column> where ...
> exec ctx_ddl.sync_index('<my_index>');
> (Doesn't matter if the above UPDATE is rolled back or not.)
>
> I presume the same would work if my column held the actual text being
> indexed. Not sure if there are extra considerations for LOB columns.
>
> John
> --
> Photo gallery: http://www.pbase.com/john_russell/
Received on Fri Aug 01 2003 - 08:31:14 CDT