Oracle数据库的dblink连接
最近在做Oracle数据库的dblink连接,在简单学习之后就直接使用命令创建了连接
create database link tieqian
connect to lms identified by lms
using ‘(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ssid)
)
)’;
命令没有问题,但是就是查询时显示链接超时,经过再次检查学习,发现自己的数据service_name 和服务名不一样,故而链接不上目标数据库再次更改了service_name之后能够正常链接查询目标数据库了select * from INT_SAP_MES2_LQ0002_BATCH@TIEQIAN![在这里插入图片描述](https://img-/ef11c4bca42346c5b853babbc2220a95.png)不止是可以使用数据库的service_name ,还可以换成是数据库的sid,只需要换成目标数据库的sid即可create database link tieqianconnect to lms identified by lmsusing '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)))(CONNECT_DATA =(SID = sid)))';