Re: How do 8i advnaced replication triggers work?

From: Anurag.Varma <avdbi_at_hotmail.com>
Date: Fri, 07 May 2004 16:41:09 GMT
Message-ID: <F_Omc.26227$L8.9412@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 Received on Fri May 07 2004 - 11:41:09 CDT