oracle 创建 dblink

来源:互联网 发布:用ps淘宝详情页怎么做 编辑:程序博客网 时间:2024/03/29 16:12


-- Drop existing database link 

drop database link UUMS_TO_TEST_FOSS;
-- Create database link 
create database link UUMS_TO_TEST_FOSS
  connect to SEARCH identified by “SEARCH”
  using '(DESCRIPTION=
    (ADDRESS=
      (PROTOCOL=TCP)
      (HOST= 192.168.10.120)
      (PORT= 1521)
    )
    (CONNECT_DATA=
      (SERVICE_NAME=fossdb)
    )
  )';
原创粉丝点击