1.语法
(1)到sys里面授权
grant CREATE PUBLIC DATABASE LINK,DROP PUBLIC DATABASE LINK to nc650115;
(2)创建DBLink
create public database link NC65DBLINK connect to nc56 identified by nc56 using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 192.168.17.254)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = orcl)))';
注意:其中NC65DBLINK 为dblink名字,connect to 需要连接的用户名 identified by 密码,HOST=需要连接数据库的ip,SERVICE_NAME=数据库实例
(3)删除DBLink
drop public database link NC65DBLINK