>> 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