ads:
关注以下公众号查看更多文章
BEGIN
ctx_ddl.drop_preference('career_file_prefs');
END;
BEGIN
ctx_ddl.create_preference (
'career_file_prefs',
'URL_DATASTORE'
) ;
END ;
//在sys下运行
conn SYS/MANAGER as sysdba
execute ctxsys.ctx_adm.set_parameter('FILE_ACCESS_ROLE','public');
//删除索引
drop index doc_career_files
//创建索引
create index doc_career_files on SRA.INDEX_CAREER_FILES(FILES)
indextype is CTXSYS.CONTEXT
parameters ('lexer MYLEXER
Filter ctxsys.inso_filter
datastore career_file_prefs');
//同步索引
begin
ctx_ddl.sync_index('doc_career_files');
end;
SELECT CAREER_ID FROM SRA.INDEX_CAREER_FILES WHERE contains(FILES, '王婷婷')>0