Not applicable

TOracleRow, turn on parallel insert

Hi,
I have job which is migrating data from MSSQL to Oracle, it looks like than:
tMSSLQTableList (which tables will bi migrated)
|
Iterate (x4 parallel)  (4 at tables at the time)
|
tOracleRow (code:
begin  
execute immediate 'truncate table <tablename>';  
insert  /*+ PARALLEL( <tablename>,4) */   into <tablename>  select  /*+ PARALLEL(<tablename>@<oracle_gateway_to_mssql>,4) */ *   from <tablename>@<oracle_gateway_to_mssql>;  
commit;  
end;'
|
error or OK output (not jet done Smiley Sad )
The parallel hints in sql are not working, I think the statement alter system enable parallel dml is missing, but I down know how to include it. The insert select is working parallel in plsql console (with alter system statement).
Thanks for the help
bye Darko
1 REPLY
Moderator

Re: TOracleRow, turn on parallel insert

Hi,
We don't use "parallel insert" in sql query before.
Can you successfully use your sql query in oracle client?
For parallel execution using sql query, have you checked this forum:https://www.talendforge.org/forum/viewtopic.php?id=37532?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.