首页 > 技术文章 > DB_LINK

ss-33 2019-01-02 11:10 原文

---目标端创建

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';

 

推荐阅读