需要先创建数据链路: create database link linkname connect to user identified by usrpwd using 'demona';//demona为用net8 easy config创建的连接字符串 目的方数据库的init.ora文件中的global_names设为false 然后写一个行级触发器传数据
CREATE OR REPLACE TRIGGER test BEFORE INSERT ON table1 FOR EACH ROW BEGIN IF (条件) then insert into table2 (col1,col2,....) values (:new.col1,:new.col2,...) END IF;END;
create database link linkname
connect to user
identified by usrpwd
using 'demona';//demona为用net8 easy config创建的连接字符串
目的方数据库的init.ora文件中的global_names设为false
然后写一个行级触发器传数据
BEFORE INSERT ON table1
FOR EACH ROW
BEGIN
IF (条件) then
insert into table2 (col1,col2,....)
values (:new.col1,:new.col2,...)
END IF;END;