当前位置: 代码迷 >> Oracle技术 >> oracle创建DBLink
  详细解决方案

oracle创建DBLink

热度:925   发布时间:2013-11-10 00:55:27.0
-- Drop existing database link  
drop database link daimami.com.RDBMS.DEV.US.ORACLE.COM; 
-- Create database link  
create database link daimami.com.RDBMS.DEV.US.ORACLE.COM 
  connect to daimami identified by pass 
  using '(DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521)) 
    ) 
    (CONNECT_DATA = 
      (SID = orcl) 
    ) 
)';

  相关解决方案