Re: ALTER TABLE modify partition rebuild unusable local indexes does not run in parallel

Harel Safra

On 26/01/2010 17:43, genegurevich_at_discover.com wrote:
> Hello:
>
> I am running this under oracle 10.2.0.3:
>
> alter table OWNER.TABLE modify partition P1 rebuild unusable local indexes
> ;
>
> The partition has 150-200M rows and three indices. All indices as well as
> the table itself are partitioned either 8 or 12 ways, but the alter table
> command seems to be only running in sequential mode (and takes over 10
> hours). Is there anyway run it in parallel?
>
> Thank you
>
> Eugene Gurevich
>
>
> Please consider the environment before printing this email.
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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