parallel dml on remote objects not working..is this documented somewhere ..any workaround..thanks
Problem Description: we have 2 databases Db1 and Db2. There exists a dblink called dblink1 between these 2 databases. There exists a procedure called procedure2 in schema2 on db2. In this procedure we enable parallel dml by using alter session.
we have a insert/*+ parallel(t,4) */ into table2 select ..from
<>t statement in this procedure. we log into db1 and through the dblink1 we call the procedure2 and ..even though the select part is getting parallelized the insert part is not getting parallelized nor is the create index statement getting parallelized.
does it come under the remote transaction restrictions?(parallel dml on remote objects do not work).If so can you point out where it is documented and if there is a workaround.
0