Re: rebuild index question?
From: Greg Rahn <greg_at_structureddata.org>
Date: Mon, 9 Jan 2012 08:34:04 -0800
Message-ID: <CAGXkmitQVhLFrw-y_KxioxOqYdBy-EajpyZEQe9584yP3Yn1Hg_at_mail.gmail.com>
You should be able to answer your own question by testing in a sandbox environment, like the SCOTT schema or similar. On Mon, Jan 9, 2012 at 8:08 AM, dba1 mcc <mccdba1_at_yahoo.com> wrote:
Date: Mon, 9 Jan 2012 08:34:04 -0800
Message-ID: <CAGXkmitQVhLFrw-y_KxioxOqYdBy-EajpyZEQe9584yP3Yn1Hg_at_mail.gmail.com>
You should be able to answer your own question by testing in a sandbox environment, like the SCOTT schema or similar. On Mon, Jan 9, 2012 at 8:08 AM, dba1 mcc <mccdba1_at_yahoo.com> wrote:
> on ORACLE 10GR2 we plan to use "alter index index_name rebuild" to rebuild
> index. For index type "normal" it is O.K.
>
> BUT I found some index type are "function_based index". Can I use "alter
> index ... rebuild" to rebuild it?
>
-- Regards, Greg Rahn | blog <http://bit.ly/u9N0i8> | twitter <http://bit.ly/v733dJ> | linkedin <http://linkd.in/gregrahn> -- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 09 2012 - 10:34:04 CST