ALTER TABLE modify partition rebuild unusable local indexes does not run in parallel
From: <genegurevich_at_discover.com>
Date: Tue, 26 Jan 2010 09:43:30 -0600
Message-ID: <OFF427426E.2B76599E-ON862576B7.0055E794-862576B7.005665F0_at_discover.com>
Hello:
Date: Tue, 26 Jan 2010 09:43:30 -0600
Message-ID: <OFF427426E.2B76599E-ON862576B7.0055E794-862576B7.005665F0_at_discover.com>
Hello:
I am running this under oracle 10.2.0.3:
alter table OWNER.TABLE modify partition P1 rebuild unusable local indexes ;
The partition has 150-200M rows and three indices. All indices as well as the table itself are partitioned either 8 or 12 ways, but the alter table command seems to be only running in sequential mode (and takes over 10 hours). Is there anyway run it in parallel?
Thank you
Eugene Gurevich
Please consider the environment before printing this email.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 26 2010 - 09:43:30 CST