oracle创建DBLink实现跨数据库

oracle创建DBLink实现跨数据库

 

create database link DblinkNC

connect to NC65READ identified by "NC65READ"

using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = orcl)))';

 

使用

select * from zt_status@DATABASE_LINKNC;

 

 

注意密码大小写，加双引号