dbms_reputil.replication_off with updatable snapshots

From: Jouko Yrjonen <jouko.yrjonen_at_tieto.com>
Date: Thu, 5 Nov 1998 12:49:24 +0200
Message-ID: <71s00t$gf1$1@hiisi.inet.fi>

It seems that dbms_reputil.replication_off doesn't work with updatable snapshots. Is this a bug or a feature ? With normal replicated tables it works fine. It can be tested easily like this:

begin
dbms_reputil.replication_off;
update <updatable snapshot name> set .... where ....; commit;
dbms_reputil.replication_on;
end;

This update shouldn't got to job queue and shouldn't replicate to the master but it does. At least with Oracle 7.3.3.6 and Alpha Open VMS.

Regards,

Maija-Leena

(Please send me email directly to address: maija-leena.kangasmaki_at_tieto.com) Received on Thu Nov 05 1998 - 04:49:24 CST