创建dblink

最新推荐文章于 2024-10-06 21:49:48 发布

dengzhuokai5682

最新推荐文章于 2024-10-06 21:49:48 发布

阅读量66

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/zhangqiao0209/p/10475570.html

版权

1.赋予权限
select * from user_sys_privs where user='zqb'and privilege like '%DATABASE LINK%';
grant create public database link to ;
2.创建DBlink
create public database link TESTLINK connect to zqb identified by "123456" using 'orcl2'
3.操作
select * from buy1s@TESTLINK;
create synonym testlinkbuy1s for buy1s@TESTLINK;

转载于:https://www.cnblogs.com/zhangqiao0209/p/10475570.html