database link

时间:2022-05-25 01:49:13

create database link lims_qumas_supply
connect to QPROCESSDEV identified by qprocessdev
using '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.73)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME =lims)))';

lims_qumas_supply:创建的数据链名称

QPROCESSDEV:要连接的目标数据库的用户名;

qprocessdev:要连接的目标数据库的密码;

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.73)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME =lims))):要连接的数据库的配置;