参考:http://hi.baidu.com/fuzylogic/blog/item/4e2532433a495f169313c685.html
http://www.join2us.com/dv_rss.asp?s=xhtml&boardid=16&id=18&page=1
一、创建dblink两种方法:(pl/sql的Sql Window和Command Window运行命令两者结果一样)
1. SQL窗口语句:
create database link dblink_name connect to user_name identified by password using ‘database_name’;
举例:
create database link linksherry connect to system identified by system using ‘bjlx’;
配置tnsnames.ora如下:
bjlx =
(DESCRIPTION =
(ADDRESS_LIST =