oracle中dblink创建

参考博客

http://xuexin25.iteye.com/blog/1924622

http://blog.youkuaiyun.com/davidhsing/article/details/6408770

http://cherryqq.iteye.com/blog/1975077

创建dblink

# 密码中有特殊字符的用双引号括起来
create public database link dblinkname    
　　connect to username identified by password 
　　using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME =  xxxx)))';