TOracleRow, turn on parallel insert

_AnonymousUser — Tue, 23 Aug 2016 12:26:58 GMT

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

Re: TOracleRow, turn on parallel insert

Anonymous — Thu, 25 Aug 2016 09:43:04 GMT

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-in-talend/td-p/111363?
Best regards
Sabrina

topic Re: TOracleRow, turn on parallel insert in Talend Studio

TOracleRow, turn on parallel insert

Re: TOracleRow, turn on parallel insert