创建dblink

来源:互联网 发布:csol神器 知乎 编辑:程序博客网 时间:2024/05/15 14:21
-- Create database link
create public database link DB_GSCM
  connect to app_gscm identified by  gscm
  using '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.88.144.238)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = SCMORATEST)
      (SERVER = DEDICATED)
    )
  )';
0 0