sql:DBlink远程连接

select * from user_sys_privs where privilege like upper('%DATABASE LINK%');  

grant create public database link to SYSTEM;  

create public database link ETPS_ORCL connect to ETPS identified by etps using '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST= 10.1.1.110)(PORT=1521))(CONNECT_DATA=(service_name=orcl)))';  

select * from dba_db_links




posted @ 2017-07-03 17:57  nobug的世界  阅读(134)  评论(0编辑  收藏  举报