Re: ALTER TABLE modify partition rebuild unusable local indexes does not run in parallel
From: Martin Bach <development_at_the-playground.de>
Date: Wed, 27 Jan 2010 10:34:41 +0000
Message-ID: <4B6016C1.10403_at_the-playground.de>
Oh la! You might want to be careful with step 2 in case you have a dataguard physical standby.
Date: Wed, 27 Jan 2010 10:34:41 +0000
Message-ID: <4B6016C1.10403_at_the-playground.de>
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-lReceived on Wed Jan 27 2010 - 04:34:41 CST