TOracleRow, turn on parallel insert

[_AnonymousUser]

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  )
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

[Anonymous]

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://community.talend.com/t5/Design-and-Development/resolved-Parallel-execution-using-mssql-query...?
Best regards
Sabrina