17,377
社区成员
发帖
与我相关
我的任务
分享
首先
在a 建个数据库链接
create database link linkname
CONNECT TO scott IDENTIFIED BY scott
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = b的ip)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = b)
)
)';
--用触发器来更新
create or replace trigger tri_b before insert on tb1 for each row
begin
insert into tb2@linkname values(:new.col,:new.col2.....);
end;