oracle创建DBLINK

需要数据库所在的机器与被链接的数据库网络是通的

create database link link_zxdb
  connect to  用户名 identified by 密码
  using '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.32.1.72)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = oadb)
    )
  )';

posted @ 2013-01-16 09:01  旦旦哥  阅读(135)  评论(0编辑  收藏  举报