Re: rebuilding text index

  • From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
  • To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 9 May 2013 09:38:53 +0100

>>  ALTER INDEX me.index1  rebuild parameters('STORAGE MYSTORE');

Looks like you've missed a word:

ALTER INDEX me.index1  rebuild parameters('replace STORAGE MYSTORE');

Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com/all-postings

Author: Oracle Core (Apress 2011)
http://www.apress.com/9781430239543


----- Original Message ----- 
From: "Andrew Kerber" <andrew.kerber@xxxxxxxxx>
To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, May 08, 2013 11:11 PM
Subject: rebuilding text index


|I dont do much with Con Text indexes, so I am probably missing something
| simple, but I am trying to move a context index to a different 
tablespace.
| I found one sample, but it is erroring out.  Can someone get me an 
example
| of the correct way to do this:
| 11gR2 on AIX
|

--
//www.freelists.org/webpage/oracle-l


Other related posts: