With regard to the index naming, is it possible to do the redef, then rename the indexes? It might take some thought, but something along the lines of generating a name on the redef, then naming the index back when complete... Not sure about a downtime requirement for renaming indexes, but if necessary it would be very short. On Thu, Jun 20, 2013 at 1:35 PM, Rich Jesse < rjoralist2@xxxxxxxxxxxxxxxxxxxxx> wrote: > > > -- > //www.freelists.org/webpage/oracle-l > > > -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- //www.freelists.org/webpage/oracle-l