DB_LINK

[mybear]

Is it possible to create a database link between two databases on two separate machines? How? Just create the link and modify both tns names files on both servers like its done when the databases are on one server?

thanks.

[sreddy]

No matter where your databases are. They must be in the network. I mean they must be registered with tbsnames.ora/names .

create database link xxxx.world
connect to user xyz identified by ****
using yyyy.world

where xyz is user on the remote machine with CREATE SESSION privilege
xxxx.world is database link
yyyy.world is service name(connect string) of remote/host machine.


The above syntax is for private link. Check docs for rest of the options like public/private/shared links.

[aracnid]

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