Oracle DBLink 脚本

来源:互联网 发布:乐期网络 编辑:程序博客网 时间:2024/06/05 00:07

DROP PUBLIC DATABASE LINK ERP_HR.WORLD;

 

create public database link ERP_HR.WORLD
connect to ERPHR identified by erphr
using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = 10.30.8.33) (PORT = 1521)))
(CONNECT_DATA = (SID = ZTETRAIN)))';

原创粉丝点击