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

On 1/27/10, Martin Bach <development_at_the-playground.de> wrote:
> Oh la! You might want to be careful with step 2 in case you have a
> dataguard physical standby.
>
> On 01/26/2010 09:27 PM, Taral Desai wrote:
>> I think this would be a way to do
>>
>> 2. ALTER INDEX owner.indexname rebuild REBUILD PARTITION <partition
>> name> NOLOGGING PARALLEL 8;
>
> -> The nologging option will certainly cause you trouble, see metalink
> note "the gains and pains of nologging operations" first.
>
> Regards,
>
> Martin
> --
> Martin Bach
> OCM 10g
> http://martincarstenbach.wordpress.com
> http://www.linkedin.com/in/martincarstenbach
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Sent from my mobile device

Thomas Roach
813-404-6066
troach_at_gmail.com
--
http://www.freelists.org/webpage/oracle-l