Transfering data from one database table to another database table

[pst]

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 schema1.table1@db1.uk.company.com)
/

where db1.uk.company.com is the dblink.