oracle创建DBLINK

需要数据库所在的机器与被链接的数据库网络是通的

create database link link_zxdb
  connect to  用户名 identified by 密码
  using '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.32.1.72)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = oadb)
    )
  )';

原文地址:https://www.cnblogs.com/hedan/p/2862184.html