oracle创建database links语句

来源:互联网 发布:淘宝摄影师接单平台 编辑:程序博客网 时间:2024/04/26 21:10

CREATE database link dblink_ciqmis
CONNECT TO byciqmis IDENTIFIED BY byciqmis
USING '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.247)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )';
0 0