如何查找全文索引的参数


创建全文索引时：
begin ctx_ddl.create_preference('club_lexer','chinese_vgram_lexer'); end;

CREATE   INDEX   INDEX_MESSAGES_TOPIC   ON   JSY_MESSAGES_INFO(TOPIC)   
      INDEXTYPE   IS   CTXSYS.CONTEXT parameters('lexer club_lexer');

我在以后创建索引时，直接使用”club_lexer'这个参数即可，但是如果我忘记了的话，我如何查找知道这个”club_lexer'啊？

I can't answer your question now. But if I were you, I would do research this way:

alter session set sql_trace=true;
begin ctx_ddl.create_preference ...
Check trace file
select * from user_objects where created > sysdate - 1/48;
Search Reference manual for a possible name
If you still can't figure out, search sql.bsq for internal tables that use the base tables you saw in the SQL trace file.
Search on Metalink
...


Yong Huang