Re: How do 8i advnaced replication triggers work?

"Anurag.Varma" <avdbi_at_hotmail.com> wrote in message news:<F_Omc.26227$L8.9412_at_nwrdny02.gnilink.net>...
> "Chris Irwin" <chrissirwin_at_yahoo.com> wrote in message news:f46814aa.0405070812.3062d91c_at_posting.google.com...
> > Hi,
> >
> > I am using Updateable Snapshot replication and have come across a
> > problem with my applicaitons row-level triggers. It seems as though
> > when a snapshot refresh occurs, an INSERT trigger is fired for each
> > row in of the tables that are replicated. Is this correct behaviour?
> > Why is it that an INSERT trigger is fired?
> >
> > Any help is appreciated.
> >
> > Thanks,
> >
> > Chris
>
> Have you replicated the triggers also. If not then maybe you need to code in the check
> dbms_mview.i_am_a_refresh ... if it returns true then have the trigger to not fire.
>
> Anurag

Anurag,

I actually found the problem. I was using the FORCE mode for the refresh and the FAST refresh mode was failing so it went to COMPLETE refresh mode which trucates the snapshot table and inserts all rows from the master site.

Thanks,

Chris Received on Tue May 11 2004 - 13:24:26 CDT