Name

DBMS_SNAPSHOT.SET_I_AM_A_REFRESH

Synopsis

The SET_I_AM_A_REFRESH procedure sets the REP$WHAT_AM_I.I_AM_A_SNAPSHOT package variable to a specified value. If this variable is TRUE, then the session making the call is performing local DML on behalf of a replicated transaction that was initiated at another master. That is, the DML performed by this session will not be replicated because it is the local application of remote DML. Use this package carefully, because disabling replication triggers effectively disables anyconflict resolution mechanisms you may have defined.

PROCEDURE DBMS_SNAPSHOT.SET_I_AM_A_REFRESH  (value IN BOOLEAN);

value is the value (Y or N) being set.

This procedure does not raise any exceptions.

Get Oracle Distributed Systems now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.