windows连接linux或者windows连接windows
由238上的连接235的一个数据库
drop public database link orcl235
@
create public database link orcl235
connect to 用户名 identified by "密码" using '
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 远程那个数据库地址)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = 远程那个数据库)
)
)'
查询sql
select * from a_organ @orcl235
添加新评论0 条评论