?? ctxmiss.sql
字號:
--創(chuàng)建存儲參數(shù)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;/--創(chuàng)建語法分析器begin ctx_ddl.create_preference('Miss_VGRAM_LEXER','chinese_vgram_lexer'); end; /BEGINctx_ddl.create_preference('Miss_LEXER','chinese_lexer');END;/-------------------創(chuàng)建各應(yīng)該表分區(qū)--t_http_contentdrop 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_contentdrop 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;
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -