create database link onss(链接名)
connect to STAGINGUSER(用户名) identified by STAGINGUSER(密码)
using 'PROSTAGE'(tns 配置名);
select * from STAGINGUSER.cti_grofags_hour@onss;
DROP DATABASE LINK onss(链接名); //删除dblink
create database link onss(链接名)
connect to STAGINGUSER(用户名) identified by STAGINGUSER(密码)
using 'PROSTAGE'(tns 配置名);
select * from STAGINGUSER.cti_grofags_hour@onss;
DROP DATABASE LINK onss(链接名); //删除dblink
转载于:https://www.cnblogs.com/lmfeng/archive/2011/08/02/2124873.html