ctxmiss.sql

来自「oracle 全文检索的示例代码. 实现基于分区表的全文检索实现」· SQL 代码 · 共 49 行

--创建存储参数
BEGIN 
    ctx_ddl.create_preference('MissStore','BASIC_STORAGE'); 
    ctx_ddl.set_attribute('MissStore','I_INDEX_CLAUSE', ' INITRANS 16  STORAGE ( FREELISTS 16 BUFFER_POOL KEEP) PARALLEL ( DEGREE 4)'); 
    ctx_ddl.set_attribute('MissStore', 'R_TABLE_CLAUSE', 'lob(data) store as (cache)'); 
    ctx_ddl.set_attribute('MissStore', 'I_TABLE_CLAUSE', 'INITRANS 16  STORAGE ( FREELISTS 16 BUFFER_POOL KEEP) PARALLEL ( DEGREE 4) tablespace I_misstbs nologging '); 
    ctx_ddl.set_attribute('MissStore', 'K_TABLE_CLAUSE', 'INITRANS 16  STORAGE ( FREELISTS 16 BUFFER_POOL KEEP) PARALLEL ( DEGREE 4) tablespace I_misstbs nologging '); 
    ctx_ddl.set_attribute('MissStore', 'N_TABLE_CLAUSE', 'INITRANS 16  STORAGE ( FREELISTS 16 BUFFER_POOL KEEP) PARALLEL ( DEGREE 4) tablespace I_misstbs nologging '); 
    ctx_ddl.set_attribute('MissStore', 'P_TABLE_CLAUSE', ' INITRANS 16  STORAGE ( FREELISTS 16 BUFFER_POOL KEEP) PARALLEL ( DEGREE 4) tablespace I_misstbs nologging ');  
end;
/

--创建语法分析器
begin 
    ctx_ddl.create_preference('Miss_VGRAM_LEXER','chinese_vgram_lexer');    
end; 
/

BEGIN
ctx_ddl.create_preference('Miss_LEXER','chinese_lexer');
END;
/


-------------------创建各应该表分区
--t_http_content
drop index idx_p_http_content force;
CREATE INDEX idx_p_http_content on T_HTTP_CONTENT(DATA) INDEXTYPE IS CTXSYS.CONTEXT 
parameters('lexer Miss_VGRAM_LEXER FILTER CTXSYS.NULL_FILTER memory 500m STORAGE MISS.MISSSTORE') 
    parallel (degree 8); 


--t_email_content    
drop index idx_p_EMAIL_content force;  
CREATE INDEX idx_p_EMAIL_content on T_EMAIL_CONTENT(MAILBODY) INDEXTYPE IS CTXSYS.CONTEXT 
parameters('lexer Miss_VGRAM_LEXER FILTER CTXSYS.NULL_FILTER memory 500m STORAGE MISS.MISSSTORE') 
    parallel (degree 8);     
      
    
--t_wap_content
drop index idx_p_WAP_content force;
CREATE INDEX idx_p_WAP_content on T_WAP_content(DATA) INDEXTYPE IS CTXSYS.CONTEXT 
parameters('lexer Miss_VGRAM_LEXER FILTER CTXSYS.INSO_FILTER memory 500m STORAGE MISS.MISSSTORE') 
    parallel (degree 8);         


exit;