I have access to one database server through a vpn connection and another through lan connection.
from my machine I would like to copy some entries from one table into the other, like:
insert into destinationtable select * from sourcetable@databaselink where id in ('id1','id2','id3')
Establishing a database link does not work because the servers cannot see each other. Is there any other way to do it?