Re: ALTER TABLE modify partition rebuild unusable local indexes does not run in parallel
From: <genegurevich_at_discover.com>
Date: Tue, 26 Jan 2010 14:56:16 -0600
Message-ID: <OFB352EBE2.8BC52268-ON862576B7.0072F4CE-862576B7.00730894_at_discover.com>
Thank you. That did not work:
ORA-14048: a partition maintenance operation may not be combined with other operations
> 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-l
>
>
>
Date: Tue, 26 Jan 2010 14:56:16 -0600
Message-ID: <OFB352EBE2.8BC52268-ON862576B7.0072F4CE-862576B7.00730894_at_discover.com>
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_at_page.discover.com
Kellyn Pedersen
<kjped1313_at_yahoo.
com> To
genegurevich_at_discover.com,
01/26/2010 02:08 harel.safra_at_gmail.com
PM cc
oracle-l_at_freelists.org
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_at_gmail.com> wrote:
From: Harel Safra <harel.safra_at_gmail.com>
Subject: Re: ALTER TABLE modify partition rebuild unusable local indexes
does not run in parallel
To: genegurevich_at_discover.com
Cc: oracle-l_at_freelists.org
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_at_discover.com 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.
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-l
Please consider the environment before printing this email.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 26 2010 - 14:56:16 CST