创建 database link

--旧环境
create /* public */ database link prod2parts
  connect to apps identified by appsr15apps
  using '(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.104)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = PROD)))';

--新环境
create /* public */ database link prod2parts
  connect to apps identified by apps
  using '(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.50)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = PROD)))';

posted @ 2018-02-07 15:20  xiaoXIAO天  阅读(104)  评论(0编辑  收藏  举报