create public database link beijing connect to user identified by "123456" using 'database'select count(*) from tablename@beijingcreate synonym test1 for tablename@beijingselect count(*) from test1select owner,object_name from dba_objects where object_type='DATABASE LINK';
create database link test connect to USER identified by PASSWORD using '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 主机名)(PORT = 端口)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = 实例名) ) )'到tnsnames.ora中将连接字符串拷贝出来. 如上使用. 一定可以.
connect to USER identified by PASSWORD
using '(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 主机名)(PORT = 端口))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = 实例名)
)
)'到tnsnames.ora中将连接字符串拷贝出来. 如上使用.
一定可以.