Oracle跨数据库查询:dblink----oracle

Oracle跨数据库查询---dblink

create public database link dblink1
connect to test identified by test                
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.11)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)';

注：连接的是是：用户test，密码test。
语法解释：create public database link DBLINK名字(根据需求自己定义，最好设置为一目了然的名字)
connect to 用户名 identified by 密码
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 要连接的数据库所在服务器的IP地址)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = 要连接的数据库的在本地的服务名(即要连接的数据库的SID))
)
)';

使用方法：
select * from test.t1@