Re: rebuild index question?

From: G <andrew.kerber_at_gmail.com>
Date: Mon, 9 Jan 2012 11:12:47 -0600
Message-Id: <4B377EA3-0DE7-47E8-B7BB-D7181770D413_at_gmail.com>

Yes, it is. You might want to rebuild online to avoid locking issues if you are on enterprise edition.

Sent from my iPhone

On Jan 9, 2012, at 10: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?
>
> Thanks.
> --
> http://www.freelists.org/webpage/oracle-l
>
>

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

Received on Mon Jan 09 2012 - 11:12:47 CST