建立DBLINK

来源:互联网 发布:天原集团历史交易数据 编辑:程序博客网 时间:2024/04/29 16:22

Create database link linkname connect to  username identified by password using
'(DESCRIPTION =
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.118)(PORT = 1521))
  )
  (CONNECT_DATA =
  (SERVICE_NAME = orcl)
  )
  )'