Skip to Main Content
Forums

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!

remote parallel index rebuild always serial

DanielDMar 9 2010 — edited Mar 11 2010
Hi,

Why is this executed serially ? (10.2.0.4)
--DST @ u1
create procedure p
is
begin
   execute immediate 'alter index usr1.idx1 rebuild parallel 10';
end;
/


-- SRC
exec p@u1;
alter session enable parallel ddl; does not help, this was tried both at source and destination(within procedure).


Thanks.

Edited by: DanielD on Mar 9, 2010 8:28 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 8 2010
Added on Mar 9 2010
#general-database-discussions
9 comments
1,161 views