Move Text Contex to different tablespace
Jump to navigation
Jump to search
- http://www.stanford.edu/dept/itss/docs/oracle/10g/text.101/b10730/cdatadic.htm#i1009245
- http://shaharear.blogspot.com/2009/04/moving-oracle-text-index.html
begin
ctx_ddl.create_preference('TEXT_INDEX_STORE', 'BASIC_STORAGE');
ctx_ddl.set_attribute('TEXT_INDEX_STORE', 'I_TABLE_CLAUSE', 'tablespace NEW_TABLESPACE');
ctx_ddl.set_attribute('TEXT_INDEX_STORE', 'K_TABLE_CLAUSE', 'tablespace NEW_TABLESPACE');
ctx_ddl.set_attribute('TEXT_INDEX_STORE', 'R_TABLE_CLAUSE', 'tablespace NEW_TABLESPACE');
ctx_ddl.set_attribute('TEXT_INDEX_STORE', 'N_TABLE_CLAUSE', 'tablespace NEW_TABLESPACE');
ctx_ddl.set_attribute('TEXT_INDEX_STORE', 'I_INDEX_CLAUSE', 'tablespace NEW_TABLESPACE COMPRESS 2');
ctx_ddl.set_attribute('TEXT_INDEX_STORE', 'P_TABLE_CLAUSE', 'tablespace NEW_TABLESPACE');
end;
create index IDX_TEXT_I on T_TAB (text_column)
indextype is ctxsys.context parameters('storage TEXT_INDEX_STORE');
