--旧环境
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)))‘;
创建 database link
标签：rip tab base protocol toc tcp creat using desc