Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Rebuild index partition in parallel

max71Oct 8 2008 — edited Oct 9 2008

I'm on 10gR2... Is there a way to parallelize following operation. If
so how...

ALTER TABLE t1 modify partition p1 rebuild unusable local indexes

specifying parallel in that statement throws "ORA-14048: a partition maintenance operation may not be combined with other operations" .

I have quite a few local indexes so this takes loong time without parallelism...

Also, Setting parallel degree at entire index level is not an option.

TIA,
Max.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 6 2008

Added on Oct 8 2008

#general-database-discussions

6 comments

3,407 views