Re: rebuilding text index
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 9 May 2013 09:38:53 +0100
Message-ID: <E143194BB75E4363B48AD2C6F6D332C7_at_Primary>
Date: Thu, 9 May 2013 09:38:53 +0100
Message-ID: <E143194BB75E4363B48AD2C6F6D332C7_at_Primary>
>> 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_at_gmail.com> To: "ORACLE-L" <oracle-l_at_freelists.org> 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 |
-- http://www.freelists.org/webpage/oracle-lReceived on Thu May 09 2013 - 10:38:53 CEST