Oracel创建dblink跨库查询 IT

创建脚本

qzqd正式数据库创建dblink访问26sjzt 、工作流 数据库
create public database link linkSjzt connect to USRNAME identified by "PASSWORD" using '(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = XXX.XXX.XXX.XXX)

create public database link linkQzqd connect to qzqd identified by "qzqd" using '(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST =XXX.XXX.XXX.XXX)(PORT = 1521)) (CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = orcl)) )';

查询当前数据有哪些dblink

select * from ALL_DB_LINKS;

删除创建的dblink

drop public database link link_name;
drop public database link linkSjzt;
drop public database link linkBbapprflow;
drop public database link linkSmz;