I have the database A in my office and database B is at client site and we connect to it through VPN. I can connect to A and B without having any problem.

I created the link in the database B pointed to the database A. when I query using the link to get data from database A and I got TNS:could nto resolve the service.

my question is ' Do I have to add the connect string to the TNS names file located on the B machine ???'

since this is at the client, is there any other way for me to move data from my office to their ???

I could use import/export but it's not an option b/c I don't have access to their server.