dblink


Create DATABASE LINK dblink_galasys CONNECT TO galasys IDENTIFIED BY "password"
      USING '(DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST =  172.16.xx.ss)(PORT = 1521)))
         (CONNECT_DATA = (SERVICE_NAME = galasys)
       )
     )';

原文地址:https://www.cnblogs.com/BrianLee/p/3650481.html