---目标端创建

SELECT * FROM DBA_DB_LINKS

Create public database link DW_TO_AC connect to chg identified by 123456 
using '(DESCRIPTION= (ADDRESS_LIST=(ADDRESS = (PROTOCOL = TCP)(HOST =1.1.11.1)(port=1521)))
(CONNECT_DATA = (SERVICE_NAME= AC )))';

SELECT * FROM AS.T_AS_PT_DL@DW_TO_AC A WHERE A.AT='20190102';

 

日积月累