Re: ALTER TABLE modify partition rebuild unusable local indexes does not run in parallel

From: Martin Bach <development@xxxxxxxxxxxxxxxxx>
To: taral.desai@xxxxxxxxx
Date: Wed, 27 Jan 2010 10:34:41 +0000

Oh la! You might want to be careful with step 2 in case you have adataguard 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 metalinknote "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-l

Follow-Ups:

Re: ALTER TABLE modify partition rebuild unusable local indexes does not run in parallel
From: Adam Musch

Re: ALTER TABLE modify partition rebuild unusable local indexes does not run in parallel
From: Taral Desai

Re: ALTER TABLE modify partition rebuild unusable local indexes does not run in parallel
From: Thomas Roach

References:
- Re: ALTER TABLE modify partition rebuild unusable local indexes does not run in parallel
  - From: Harel Safra
- Re: ALTER TABLE modify partition rebuild unusable local indexes does not run in parallel
  - From: genegurevich
- Re: ALTER TABLE modify partition rebuild unusable local indexes does not run in parallel
  - From: Taral Desai

Re: ALTER TABLE modify partition rebuild unusable local indexes does not run in parallel

Other related posts: