Thank you. That did not work: alter table Owner.Table parallel (degree 2) modify partition P200711 rebuild unusable local indexes ; alter table owner.table parallel (degree 2) modify partition P200711 rebuild unusable local indexes * ERROR at line 1: ORA-14048: a partition maintenance operation may not be combined with other operations Thank you Eugene Gurevich | Discover Sr. Associate, Database Engineering and Operations Enterprise Data Management (EDM) 2500 Lake Cook Road, Riverwoods IL 60015 Phone - 224-405-4079 Fax - 224-405-4967 Page - genegurevich@xxxxxxxxxxxxxxxxx Kellyn Pedersen <kjped1313@yahoo. com> To genegurevich@xxxxxxxxxxxx, 01/26/2010 02:08 harel.safra@xxxxxxxxx PM cc oracle-l@xxxxxxxxxxxxx Subject Re: ALTER TABLE modify partition rebuild unusable local indexes does not run in parallel alter table OWNER.TABLE PARALLEL(degree 6) modify partition P1 rebuild unusable local indexes I've never had the opportunity to try this combination of commands, but this might do it... Kellyn Pedersen Multi-Platform DBA I-Behavior Inc. http://www.linkedin.com/in/kellynpedersen www.dbakevlar.blogspot.com "Go away before I replace you with a very small and efficient shell script..." --- On Tue, 1/26/10, Harel Safra <harel.safra@xxxxxxxxx> wrote: From: Harel Safra <harel.safra@xxxxxxxxx> Subject: Re: ALTER TABLE modify partition rebuild unusable local indexes does not run in parallel To: genegurevich@xxxxxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Date: Tuesday, January 26, 2010, 12:41 PM Just checking, you do have "degree" defined as greater than 1 on those indexes? Harel Safra On 26/01/2010 17:43, genegurevich@xxxxxxxxxxxx wrote: > 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. > > > -- > //www.freelists.org/webpage/oracle-l > > > -- //www.freelists.org/webpage/oracle-l Please consider the environment before printing this email. -- //www.freelists.org/webpage/oracle-l