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