Re: ALTER TABLE modify partition rebuild unusable local indexes does not run in parallel
- From: Taral Desai <taral.desai@xxxxxxxxx>
- To: Martin Bach <development@xxxxxxxxxxxxxxxxx>
- Date: Wed, 27 Jan 2010 10:28:24 -0600
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@xxxxxxxxxxxxxxxxx>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."
Other related posts:
