You may use "COPY" command from sql, to copy data from a remote database without dblink creation (use sqlnet connection)