create public database link mylink connect to orclname identified by orclpasswd using 'ORCL';
drop public database link mylink;
select count(1) from tabname@mylink;
create public database link mylink connect to orclname identified by orclpasswd using 'ORCL';
drop public database link mylink;
select count(1) from tabname@mylink;
转载于:https://www.cnblogs.com/xiufengd/p/4736734.html