create public database link test_link
connect to test
identified by "test"
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora9i)
)
)';
create public database link 名字
connect to 用户名
identified by "密码"
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 地址)(PORT = 端口))
)
(CONNECT_DATA =
(SERVICE_NAME = SID)
)
)';
查询时使用 select * from table@test_link