Re: ALTER TABLE modify partition rebuild unusable local indexes does not run in parallel
From: Taral Desai <taral.desai_at_gmail.com>
Date: Wed, 27 Jan 2010 10:28:24 -0600
Message-ID: <2b0cd5cd1001270828q3337a76ak41c399050e1b5747_at_mail.gmail.com>
Thanks Martin for that. Yes is you are using any replication then this might cause a problem
Date: Wed, 27 Jan 2010 10:28:24 -0600
Message-ID: <2b0cd5cd1001270828q3337a76ak41c399050e1b5747_at_mail.gmail.com>
Thanks Martin for that. Yes is you are using any replication then this might cause a problem
On Wed, Jan 27, 2010 at 4:34 AM, 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
>
-- Thanks & Regards, Taral Desai Samuel Goldwyn<http://www.brainyquote.com/quotes/authors/s/samuel_goldwyn.html> - "I'm willing to admit that I may not always be right, but I am never wrong." -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 27 2010 - 10:28:24 CST