全文索引
如果不做任何设置，Oracle缺省使用basic_lexer这个分析器。要指定使用哪一个lexer,可以这样操作：
BEGIN
ctx_ddl.create_preference ('my_lexer', 'chinese_vgram_lexer');
END;
/
其中my_lexer是分析器名。
二、建立全文索引
在建立intermedia索引时，指明所用的lexer:
CREATE INDEX myindex ON mytable(mycolumn) indextype is ctxsys.context parameters('lexer my_lexer');
SQL> conn tskfdis/tskfdis
Connected.
SQL> begin
2 ctx_ddl.create_preference ('TSKFDIS_CHINESE_LEXER','chinese_vgram_lexer');
3 end;
4 /
PL/SQL procedure successfully completed.
SQL> conn testtskfdis/testtskfdis
Connected.
SQL> begin
2 ctx_ddl.create_preference ('TESTTSKFDIS_CHINESE_LEXER','chinese_vgram_lexer');
3 end;
4 /
PL/SQL procedure successfully completed.
SQL> conn dg/dg
Connected.
SQL> show user
USER is "DG"
SQL> begin
2 ctx_ddl.create_preference ('DG_CHINESE_LEXER','chinese_vgram_lexer');
3 end;
4 /
PL/SQL procedure successfully completed.
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
SIMPLIFIED CHINESE_AMERICA.ZHS16GBK
SELECT COUNT (*)
FROM user_objects
WHERE object_type IN ('PROCEDURE','FUNCTION','TRIGGER','VIEW','PACKAGE')
AND status = 'INVALID';
①重建em资料
[oracle@localhost OC4J_DBConsole]$ emca -repos recreate
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/15037413/viewspace-674786/ ，如需转载，请注明出处，否则将追究法律责任。
