ORACLE建立DATABASE LINK

1, 建立连接

drop database link source_link;
create database link source_link
　　 connect to user identified by password
　　 using
'(DESCRIPTION =
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
  )
  (CONNECT_DATA =
  (SERVICE_NAME = orcl)
  )
  )'
;

2, 查询数据

select * from testtable@source_link;