Re: No future for DB2

From: Mark Malakanov <markmal_at_rogers.com>
Date: Wed, 03 Aug 2005 21:20:42 -0400
Message-ID: <xLydnbH1n-Pl8GzfRVn-tQ@rogers.com>

Madison Pruet wrote:
> At a minimun the replication solution should be able to either prevent
> triggers from firing on the target if it is populated by a replication
> apply, with the assumption (and policing) that all of the tables associated
> with original transaction is replicated as part of that transaction.

Yes, there is a function that should be called in an updateable MV target table trigger DBMS_MVIEW.I_AM_A_REFRESH. It returns FALSE if trigger is fired by local changes, and TRUE if trigger is fired by replication. Received on Wed Aug 03 2005 - 20:20:42 CDT