parallel DDL [message #464627] |
Thu, 08 July 2010 09:33 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
arunprasad_bh
Messages: 32 Registered: June 2007
|
Member |
|
|
Hi,
Is it possible to build index partition in parallel?
I tried following command
alter index <index_name> rebuild partition <partition name> online parallel 5;
It executed without complaining, but want to know if index partitions can be build in parallel?
Thanks for your help.
Arun
|
|
|
|
Re: parallel DDL [message #464631 is a reply to message #464627] |
Thu, 08 July 2010 09:50 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68665 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Now what could we answer you? Yes, no, would you trust us? I advice you no.
Execute your statement and have a look if some Pxxx processes work.
You have to first enable parallel DDL with an ALTER SESSION statement.
Regards
Michel
[Updated on: Thu, 08 July 2010 09:52] Report message to a moderator
|
|
|
|