I have policy created on one of my text column of length
( varchar2 (500)). Whenever i am adding a new record for the text column table or updating text information, my search result do not bring those modified and new values. In conclusion my policy indexes are not getting updated by itself ( automatically ). I was wondering how i can find the way to make the index updation automatic.
Looking forward for early and valuable reply.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Well done bahadir, u have given the right answer. I tried yesterday and it worked fine. Could you please further send me your email address ( if you have not objection )also to correspond with you in near future. I feel you are the right person ( master ) in oracle context server. Furhter i am looking for some training course in oracle context server, could you please guide and advice.
regards
sanjay
Business Accounts
Answer for Membership
by: bahadirPosted on 1999-08-09 at 01:08:00ID: 1088150
i have a problem like this one ... you are right ... automatic indexing is not working ... so i use ctx_dml.reindex function ... use like this ... here is the example...................
create table documan_table
(doc_id number not null ,
doc_text long,
primary key(doc_id));
/
insert into documan_table values(1,'packman');
insert into documan_table values(2,'packman packman i have seen him before there');
insert into documan_table values(3,'there WAS A TIME WHEN I WAS SO BROKEN HEARTED');
insert into documan_table values(4,'as long as we are together who cares about the wheather ...');
create or replace trigger documan_table_ait
after insert on documan_table
for each row
begin
deneme(:NEW.doc_id);
exception
when others then raise;
end;
create or replace procedure deneme(a in number) is
begin
ctx_dml.reindex('CTX_DOCUM
exception
when others then raise;
end;
/
EXEC CTX_DDL.CREATE_POLICY('ctx
/
exec ctx_ddl.create_index('ctx_
/
create table documan_result_table
(textkey varchar2(64),score number,conid number);
/