目标数据库信息:

目标数据库IP:192.168.0.79
端口:1521
服务实例名: xxls
密码: mima

创建语句:

create database link your_dblink_name
       connect to xxls identified by mima
       using'(DESCRIPTION =
              (ADDRESS_LIST =
                (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.79)(PORT = 1521))
              )
              (CONNECT_DATA =
                (SERVICE_NAME = mima)
              )
            )'

字段说明

your_dblink_name:你创建的DBlink名称,自己自定义命名的

xxls: 链接目标库的实例名