ORACLE DBLINK

create database link CDRjinan
　connect to username  identified by "password"
　　 using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = HLHT3) ) )';

 

SELECT * FROM worker@CDRjinan;

因为此处有BUG 密码必须加双引号