Oracle全文检索步骤

alter user ctxsys account unlock; //解锁
grant execute on ctx_ddl to testuser;  //赋权限
exec ctx_ddl.create_preference ('my_lexer', 'chinese_vgram_lexer');//创建分析器
create index YU_TEST_INDEX on YU_TEST(name) indextype is CTXSYS.CONTEXT parameters('lexer my_lexer')//对表创建索引
exec ctx_ddl.sync_index('yu_test_index') //索引同步
exec ctx_ddl.optimize_index('yu_test_index','full') //索引优化
select * from YU_TEST where contains(name,'重庆')>0; //查询