-- Create database link
connect to PORTAL
using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 192.168.1.120)(PORT = 11521)))(CONNECT_DATA =(SERVICE_NAME = 实例名)))';
select * from 表名@XXXX20
-- Create database link
using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 192.168.1.120)(PORT = 11521)))(CONNECT_DATA =(SERVICE_NAME = 实例名)))';
select * from 表名@XXXX20