创建dblink:
create database link 名字
connect to 要连接的用户名 identified by 密码 --(可以用双引号括起来)
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP号)(PORT = 端口号))
)
(CONNECT_DATA =
(SERVICE_NAME = service) --service自己填充
))';
创建dblink下的同义词:
create or replace synonym 同义词名
for dblink中表名 @ dblink名字;