急需:Oracle9i数据库创建链路
-----创建链路----------
create database link orcl
connect to frame identified by frame
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.19.16)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)';
-----执行插入操作------
INSERT INTO sdp_status SELECT * FROM sdp_status@orcl_172.16.19.16;
报:ERA-00933:SQL命令未正确结束