oracle：db-link使用

create public database link 链接名
  connect to 用户名 identified by 密码
  using '(DESCRIPTION =  
    (ADDRESS = (PROTOCOL = TCP)(HOST = 服务器IP)(PORT = 1521))   
    (CONNECT_DATA =  
      (SERVER = DEDICATED)  
      (SERVICE_NAME = orcltest)  
    )  
)';

select * from 表名@链接名;