Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Incremental indexing in Oracle Text

Re: Incremental indexing in Oracle Text

From: Russell Lear <russelllear_at_earthlink.net>
Date: Fri, 01 Aug 2003 13:31:14 GMT
Message-ID: <CYtWa.1561$jg7.1494@newsread3.news.pas.earthlink.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US