oracle-创建dblink

create public database link dblinkname
  connect to 远程数据库用户 identified by 远程数据库密码 
  using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = ipaddress)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = serviceName)))';

原文地址:https://www.cnblogs.com/zjxbetter/p/5535126.html