oracle使用快照和触发器同步不同数据库中的表数据
假设有数据库db1和db2 , 表db1.t_task_msg, db2.t_task_msg
现在同步db1.t_task_msg数据到db2.t_task_msg
1, 在db2建立到db1的连接source_link
create or replace trigger tr_t_task_msg after insert or update or delete on sn_t_task_msg for each rowbegin if deleting then delete from t_task_msg where fid=:old.fid; end if; if inserting then insert into t_task_msg(fid,fserviceid,fcontent,fuserid,fstate,finserttime) values(:new.fid,:new.fserviceid,:new.fcontent,:new.fuserid,:new.fstate,:new.finserttime); end if; if updating then update t_task_msg set fserviceid=:new.fserviceid, fcontent=:new.fcontent, fuserid=:new.fuserid, fstate=:new.fstate, finserttime=:new.finserttime where fid=:old.fid; end if;end tr_t_task_msg;
