ORACLE 跨库查询语句 DBLINK

来源:互联网 发布:淘宝快递助手 编辑:程序博客网 时间:2024/05/22 04:29


drop public database link dblinktoGroupTest3


create public DATABASE link dblinktoGroupTest3
connect to galasysuser identified by 123
using
'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.199.201.92)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=tbpub2)))'


SELECT * FROM galasysuser.GS_SR_L_PHONEMANAGEINPUT@dblinktoGroupTest3
0 0
原创粉丝点击