-- Create database link
create database link link名
connect to 用户名 identified by 密码
using 'lbsdata' --服务名
或者
'(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.246)(PORT = 1521))(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = LBSDATA)
)
)';
向ba22中插入dais数据库中的ba22表