??????ó?????
???????????????????????????????????????Oracle??????????????????????????????а??????????????????
???????????????????
????1?????oracle????????ctxsys??????????и?????????????????????????????????????????????????ο????????
????2??????????ctxsys??????????ò??裻
??????1??dba?????SQLPLUS????????????????????
????create tablespace textidx datafile '/oradata/textidx/ctxsys.dbf size 10240M autoextend on next 32M maxsize 20480M;
??????2?????oracle??????????$ORACLE_HOME/ctx/admin/catctx.sql
????@?/ctx/admin/catctx.sql ctxsystextidxtemp nolock
?????????????ctxsys?ctxsys?????????
?????????????textidx?ctxsys???????????
??????????????temp?ctxsys??????????????
?????????????nolock?ctxsys??????????????
??????3????ctxsys?????????н??
????connect ctxsys/ctxsys
???????????????@?/ctx/admin/defaults/drdefus.sql
??????????????????????
????1??????????????????磺user??????????????????
????grant execute on ctxsys.ctx_ddl to user with grant option;
????2??????????????
????exec ctx_ddl.create_preference ('my_lexer'?? 'chinese_vgram_lexer');
???????????????????????????????????????????
????????????????????????????????????????????????
????basic_lexer????????????
????chinese_vgram_lexer??????????????????е?????????????е????
???????磺???????????????????????????????????????
????chinese_lexer???°?????????????????UTF-8????????????????????Ч??????
???????磺????????????????????????????
????3?????????ν??????????????????????????
????CREATE INDEX content_textidx ON tableName(columnName) indextype is ctxsys.context parameters('lexer my_lexersync(on commit)');
????????lexer: ????????????????????
????????sync(on commit): ??????????????????????????????????????????