Oracle DB Link创建

create database link link_dy connect to dyrs identified by dyrs_x using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 133.61.9.18)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = dyars) ) )'

using='',单引号里的为数据库的TNS。不要别名

 

访问：select * from log_proc_run@link_dy  (log_proc_run为数据库133.61.9.18里面的一个表)，link_dy 是上面sql创建的db link名字