Re: rebuild index question?

  • From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
  • To: mccdba1@xxxxxxxxx
  • Date: Mon, 9 Jan 2012 08:34:04 -0800

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


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


Other related posts: