创建 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)))‘;

创建 database link

标签：rip   tab   base   protocol   toc   tcp   creat   using   desc