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;