Difference between revisions of "Move Text Contex to different tablespace"
Jump to navigation
Jump to search
(Created page with "* http://www.stanford.edu/dept/itss/docs/oracle/10g/text.101/b10730/cdatadic.htm#i1009245 <pre> begin ctx_ddl.create_preference('TEXT_INDEX_STORE', 'BASIC_STORAGE'); ctx_ddl.set...") |
|||
| Line 1: | Line 1: | ||
* http://www.stanford.edu/dept/itss/docs/oracle/10g/text.101/b10730/cdatadic.htm#i1009245 | * 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 | ||
<pre> | <pre> | ||
Latest revision as of 16:45, 2 January 2013
- 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');
