oracle-dblink

创建dblink

create public database link citic_market
    connect to jh4jtest identified by jh4jtest
    using
        '(DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST =172.1.201.155)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = ZTYXDEV))
          )';