当前位置: 代码迷 >> 综合 >> Oracle # 创建数据库链接(dblink)
  详细解决方案

Oracle # 创建数据库链接(dblink)

热度:14   发布时间:2024-02-12 11:45:31.0

语法:

create database link 链接名称
connect to 账号 identified by 密码
using ' (DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 1521)))(CONNECT_DATA =(SID = orcl)))';
create database link 链接名称
connect to 账号 identified by 密码
using ' (DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = orcl)))';

将一些配置信息修改成为自己的。

  相关解决方案