建立一個連結到其他資料庫的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';