https://ittichaicham.com/wiki/index.php?action=history&feed=atom&title=Move_Text_Contex_to_different_tablespace 2026-10-17T02:38:25Z Revision history for this page on the wiki MediaWiki 1.34.2 https://ittichaicham.com/wiki/index.php?title=Move_Text_Contex_to_different_tablespace&diff=839&oldid=prev 2013-01-02T21:45:38Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">Revision as of 21:45, 2 January 2013</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* http://www.stanford.edu/dept/itss/docs/oracle/10g/text.101/b10730/cdatadic.htm#i1009245</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* http://www.stanford.edu/dept/itss/docs/oracle/10g/text.101/b10730/cdatadic.htm#i1009245</div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* http://shaharear.blogspot.com/2009/04/moving-oracle-text-index.html</ins></div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;pre&gt;</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;pre&gt;</div></td></tr> </table>

Ittichai https://ittichaicham.com/wiki/index.php?title=Move_Text_Contex_to_different_tablespace&diff=838&oldid=prev 2013-01-02T21:45:00Z

<p>Created page with &quot;* http://www.stanford.edu/dept/itss/docs/oracle/10g/text.101/b10730/cdatadic.htm#i1009245 &lt;pre&gt; begin ctx_ddl.create_preference(&#039;TEXT_INDEX_STORE&#039;, &#039;BASIC_STORAGE&#039;); ctx_ddl.set...&quot;</p> <p><b>New page</b></p><div>* http://www.stanford.edu/dept/itss/docs/oracle/10g/text.101/b10730/cdatadic.htm#i1009245<br /> <br /> &lt;pre&gt;<br /> begin<br /> ctx_ddl.create_preference(&#039;TEXT_INDEX_STORE&#039;, &#039;BASIC_STORAGE&#039;);<br /> ctx_ddl.set_attribute(&#039;TEXT_INDEX_STORE&#039;, &#039;I_TABLE_CLAUSE&#039;, &#039;tablespace NEW_TABLESPACE&#039;);<br /> ctx_ddl.set_attribute(&#039;TEXT_INDEX_STORE&#039;, &#039;K_TABLE_CLAUSE&#039;, &#039;tablespace NEW_TABLESPACE&#039;);<br /> ctx_ddl.set_attribute(&#039;TEXT_INDEX_STORE&#039;, &#039;R_TABLE_CLAUSE&#039;, &#039;tablespace NEW_TABLESPACE&#039;);<br /> ctx_ddl.set_attribute(&#039;TEXT_INDEX_STORE&#039;, &#039;N_TABLE_CLAUSE&#039;, &#039;tablespace NEW_TABLESPACE&#039;);<br /> ctx_ddl.set_attribute(&#039;TEXT_INDEX_STORE&#039;, &#039;I_INDEX_CLAUSE&#039;, &#039;tablespace NEW_TABLESPACE COMPRESS 2&#039;);<br /> ctx_ddl.set_attribute(&#039;TEXT_INDEX_STORE&#039;, &#039;P_TABLE_CLAUSE&#039;, &#039;tablespace NEW_TABLESPACE&#039;);<br /> end;<br /> <br /> <br /> create index IDX_TEXT_I on T_TAB (text_column)<br /> indextype is ctxsys.context parameters(&#039;storage TEXT_INDEX_STORE&#039;);<br /> &lt;/pre&gt;<br /> <br /> [[Category: Oracle Database]]</div>

Ittichai