Oracle10g 创建远程连接

来源:互联网 发布:手机淘宝店铺招牌素材 编辑:程序博客网 时间:2024/04/30 13:18

语法如下:

      create public database link remote_connect
       connect to gzs identified by gzs
       using
       '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 10.11.0.31)(PORT = 1521)))
                     (CONNECT_DATA =(SERVICE_NAME = ORCL)))';

原创粉丝点击