Re: ALTER TABLE modify partition rebuild unusable local indexes does not run in parallel
Date: Wed, 27 Jan 2010 11:56:30 -0500
What if your db is in "force logging" mode?
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.
> Martin Bach
> OCM 10g
-- Sent from my mobile device Thomas Roach 813-404-6066 troach_at_gmail.com -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 27 2010 - 10:56:30 CST