2011年4月1日 星期五

Oracle 全文檢索

參考文章
http://space.itpub.net/13379967/viewspace-474767
oracle全文檢索(oracle text)
http://winie.javaeye.com/blog/663835
http://hi.baidu.com/lzycsd/blog/item/f083473835da4f2897ddd878.html
1.

create table WT_LIGHTING_S_INDEX
(
  SOURCE_ID   NUMBER,
  ID          NUMBER,
  DESC1       VARCHAR2(4000),
  CREATE_DATE DATE
)


2.ctx_ddl.create_preference ('lighting_lexer', 'chinese_lexer');

3.CREATE INDEX wt_lighting_index ON WT_LIGHTING_S_INDEX(DESC1)

indextype is ctxsys.context parameters('lexer lighting_lexer');

alter user lighting quota unlimited on users;

 GRANT EXECUTE ON CTXSYS.CTX_DDL