创建一个链接到其他数据库的DBLINK

1. --创建一个链接到其他数据库的链接
   
2. --USING 'BitOrcl' 中的 BitOrcl 为 tnsnames.ora 中配置
   
3. 
   
4. CREATE SHARED PUBLIC DATABASE LINK BitOrcl
   
5. AUTHENTICATED BY SYS IDENTIFIED BY his
   
6. USING 'BitOrcl' ;
   
7. 
   
8. --使用方法,在表格后面加上需要链接数据库的DBLink名：
   
9. 
   
10. SELECT * FROM 人员表@BitOral ;
    
11. 
    
12. --删除DBLink
    
13. DROP PUBLIC DATABASE LINK BitOral ;
    
14. 
    
15. --创建一个连接到电子病历服务器的链接
    
16. CREATE SHARED PUBLIC DATABASE LINK EmrOrcl
    
17. AUTHENTICATED BY SYS IDENTIFIED BY his
    
18. USING '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.71.103)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = emrorcl)))' ;
    
19. 
    
20. --删除DBLink
    
21. DROP PUBLIC DATABASE LINK EmrOrcl ;
    
22. 
    
23. --创建一个连接到测试服务器的链接
    
24. CREATE PUBLIC DATABASE LINK BitTest
    
25. CONNECT TO SYS IDENTIFIED BY his
    
26. USING '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.71.115)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = orcl)))' ;
    
27. 
    
28. CREATE PUBLIC DATABASE LINK Hisinterface
    
29. CONNECT TO ZLHIS IDENTIFIED BY HIS
    
30. USING '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.168.110)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = orcl)))' ;
    
31. 
    
32. --删除DBLink
    
33. DROP PUBLIC DATABASE LINK BitTest ;

 --创建一个简易的dblink
 create public database link HisInterface connect to zlhis identified by his using '192.168.168.110:1521/orcl';

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28878983/viewspace-2133926/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28878983/viewspace-2133926/