Rebuild index partition in parallel
From: <maks71_at_gmail.com>
Date: Tue, 7 Oct 2008 14:30:37 -0700 (PDT)
Message-ID: <430b9a79-dae3-41a3-b096-31f451bb5b30@42g2000pry.googlegroups.com>
Date: Tue, 7 Oct 2008 14:30:37 -0700 (PDT)
Message-ID: <430b9a79-dae3-41a3-b096-31f451bb5b30@42g2000pry.googlegroups.com>
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"
Setting parallel degree at entire index level is not an option. Received on Tue Oct 07 2008 - 16:30:37 CDT