Re: rebuilding text index

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Thu, 9 May 2013 08:57:59 -0500
Message-ID: <CAJvnOJbOdGCebwNkWyLtaS=pEwX2wwyAZWN4ayxmooG1AMKg1w_at_mail.gmail.com>

thank you Jonathon, that got it. I only had to change it like this, and that is from my bad habit of doing most of my work as sys: ALTER INDEX me.index1 rebuild parameters('replace STORAGE SYS.MYSTORE');

On Thu, May 9, 2013 at 3:38 AM, Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>wrote:

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

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'


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

Received on Thu May 09 2013 - 15:57:59 CEST