Re: ALTER TABLE modify partition rebuild unusable local indexes does not run in parallel
- From: Thomas Roach <troach@xxxxxxxxx>
- To: development@xxxxxxxxxxxxxxxxx, taral.desai@xxxxxxxxx, genegurevich@xxxxxxxxxxxx, Harel Safra <harel.safra@xxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- 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@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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Sent from my mobile device
Thomas Roach
813-404-6066
troach@xxxxxxxxx
--
//www.freelists.org/webpage/oracle-l
Other related posts:
