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)))';
zjxbetter 2016-05-27 16:33 原文
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)))';