全文索引实现

1.解锁用户ctxsys

alter user ctxsys account unlock

2.

select * from ecc_csc.cc_sr_request

GRANT ctxapp TO foo;

GRANT execute ON ctxsys. ctx_cls TO foo;

GRANT execute ON ctxsys. ctx_ddl TO foo;

GRANT execute ON ctxsys. ctx_doc TO foo;

GRANT execute ON ctxsys. ctx_output TO foo;

GRANT execute ON ctxsys. ctx_query TO foo;

GRANT execute ON ctxsys. ctx_report TO foo;

GRANT execute ON ctxsys. ctx_thes TO foo;

GRANT execute ON ctxsys. ctx_ulexer TO foo

3.指定分词器

BEGIN

ctx_ddl.create_preference ( ‘my_lexer’, ‘chinese_vgram_lexer’ );

END;

BEGIN

ctx_ddl.create_preference( ‘test_store’,’BASIC_STORAGE’ );

end;

select * from all_users

Select pre_name, pre_object from ctx_preferences

select * from shaotestcdx

insert into shaotestcdx values ( 3,’文档,DSDSD,TEST,测试’ ,779, ‘文档试’);

insert into shaotestcdx values ( 3,’文档,DSDSD,TEST,测试’ ,780, ‘文档,TEST,测试’ );

insert into shaotestcdx values ( 3,’文档,DSDSD,TEST,测试’ ,781, ‘DSDSD,TEST,测试’);

insert into shaotestcdx values ( 3,’文档,DSDSD,TEST,测试’ ,780, ‘文档,TEST,测试’ );

insert into shaotestcdx values ( 3,’文档,DSDSD,TEST,测试’ ,781, ‘文档,DSDSD,TEST’);

--Create index cdx_idx on shaotestcdx(content)

--indextype is ctxsys.context parameters

--( ‘filter ctxsys.null_filter section group ctxsys.html_section_group’);

/创建索引，指定分词器给索引/

CREATE INDEX cdx_idx ON shaotestcdx(mycontent) indextype is ctxsys.context parameters (‘lexer my_lexer’);

/维护以及更新索引/

begin

ctx_ddl.sync_index ( ‘cdx_idx’);

end;

drop index cdx_idx;

select * from v$datafile;

select * from shaotestcdx where mycontent like ‘%TEST%’

select * from shaotestcdx where contains(mycontent, ‘TEST’) > 0

/查索引基础表/

select * from dr$cdx_idx$I