Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CTXSYS.Context INDEX REBUILD AFTER ADDING NEW RECORDS to search

288486Aug 6 2002

I have the following table:

create table news(
id number Primary Key,
title varchar2(1000),
article blob default empty_blob());

create index idx_news_context on news(article) indextype is ctxsys.context;

The problem is that I have to rebuild the index on the complete table after adding any new record into the table, so that I can search the article with contains clause.

This takes a lot of time to rebuild after any insert or even in batch mode as the no. of records increases.

Any solution.
I would appreciate if u can drop me the way out on tsi2002@indiatimes.com
Thanks in advance..
Tech

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 11 2002

Added on Aug 6 2002

#database-key-features, #text

3 comments

1,724 views