Re: ALTER TABLE modify partition rebuild unusable local indexes does not run in parallel
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_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
-- 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