目标数据库信息:
目标数据库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: 链接目标库的实例名