oracle创建dblink的脚本

创建dblink的脚本

create public database link wsbsbb_27（dblink名字） connect to wsbsbb（用户名） IDENTIFIED BY wsbsbb （密码） using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST =10.92.131.27)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME =wsbsbb) （实例）))';

 

create public database link wsbsbb_27connect to wsbsbb  IDENTIFIED BY wsbsbb using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST =10.92.131.27)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME =wsbsbb) )';

 

SELECT * FROM ac56_nh@wsbsbb_27；

转载于:https://www.cnblogs.com/weiyi1314/p/10150286.html

相关资源：dblink创建语句（Oracle