创建dblink
CREATE DATABASE LINK DBLINKNAME CONNECT TO USERNAME IDENTIFIED BY PASSWORD USING 'SERVICENAME';
CONN USER/PASSWORD@DBLINKNAME
CREATE DATABASE LINK DBLINKNAME CONNECT TO USERNAME IDENTIFIED BY PASSWORD USING 'SERVICENAME';
CONN USER/PASSWORD@DBLINKNAME
别名远程的主机地址或主机名远程数据库的sid即可
例如:qzyb.world = (数据库别名)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 192.168.0.15)胜古迹 (主机的IP地址或主机名)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ydorcl)(sid默认一般为orcl)
)
)
如果是装的是8.1.6像hobo_boy(流浪汉)所说