环境:oracle 11g
# 查询dblink SQL
select * from dba_db_links;
select * from all_db_links;
#创建dblink
create public database link dl_oa connect to sys identified by "OA@#@123"
using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME =orcl)))';
# 若用户没有权限创建dblink,则授权
grant create public database link,drop public database link to 用户;
补充:oracle-sqlserver --Oracle Gateways的安装与配置,实现与sqlserver 连接