You could try this as well. But you will need to have dblink estabilished before the insert.
Assuming you want to copy table data from table schema1.table1 in db1 to table schema1.table1 in db2.
insert /*+APPEND */ into schema1.table1 nologging
(select /*+PARALLEL(schema1.tablename,4)*/ *
from [email protected])
/
where db1.uk.company.com is the dblink.
