创建一个链接 然后create or replace trigger emp_ins after insert on emp for each row begin insert into remote_emp@dblink_emp2 values(:new.deptno,:new.ename,:new.sal..);
create or replace trigger YOUR_TRIGGER_NAME before insert or update on TABLE_NAME for each rowdeclare -- local variables here begin if :new.COLUMN_VALUE null then :new.COLUMN_VALUE := sysdate; end if;
然后create or replace trigger emp_ins
after insert on emp for each row
begin
insert into remote_emp@dblink_emp2
values(:new.deptno,:new.ename,:new.sal..);
before insert or update on TABLE_NAME for each rowdeclare
-- local variables here
begin
if :new.COLUMN_VALUE null then
:new.COLUMN_VALUE := sysdate;
end if;
触发器写法参考:
http://www.ahetc.gov.cn/cit/200108/06.doc
在serverB上创建一个触发器,
serverB上的触发器调用serverA上的过程。
execute procedure@db_link;
CREATE PUBLIC DATABASE LINK dblink
CONNECT TO user IDENTIFIED BY password
USING 'connect_string';
其中:'connect_string'是远程数据库的TNS名。