Database DataWarehousing (MOSC)

MOSC Banner

parallel dml on remote objects not working..is this documented somewhere ..any workaround..thanks

edited Oct 7, 2010 8:28PM in Database DataWarehousing (MOSC) 4 commentsAnswered
 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center