Re: Updateable Snapshot changes sent back from master on refresh?

Hi,

I don't really understand your question, but in a replication environement, triggers had to be modified to not fire if DML are from a remote site.

An example of a trigger :

create or replace trigger trg_T1
before insert or update
on T1
for each row
declare
...
begin
if (dbms_reputil.from_remote = false) then ...
end if;
end;

Dias

chrissirwin_at_yahoo.com (Chris Irwin) wrote in message news:<f46814aa.0405181304.3577a803_at_posting.google.com>...
> Hi,
>
> I have setup Updateable Snapshots on Oracle 8i with one master and one
> snapshot site. I have before row triggers defined on the snapshot site
> on the tables that are replicated from the master site.
>
> When I make a chnage to a table on the snapshot site and do a fast
> refresh, which pushes the snapshot changes to the master first, my
> UPDATING trigger fires with all values being exactly what was pushed
> over to the master site. I was just wondering whether this si correct
> beahviour?
>
> It's only a problem for me because we are creating versions of the
> table rows when they are updated and this of course creates an extra
> version of the just updated row.
>
> Thanks,
>
> Chris
Received on Wed May 19 2004 - 14:36:49 CDT