Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_SNAPSHOT.SET_I_AM_A_REFRESH

Purpose

To set the I_AM_REFRESH package state to the appropriate value. For additional information, refer to

Syntax

The parameter for the SET_I_AM_A_REFRESH procedure is described in Table 12 - 189. The syntax for this procedure is shown below.

DBMS_SNAPSHOT.SET_I_AM_A_REFRESH(value IN BOOLEAN)

parameter description
value Value that you want to set the I_AM_A_REFRESH package state to. If this state is set to TRUE, all local replication triggers for snapshots will be effectively disabled in this session because each replication trigger first checks this state. If this state is set to FALSE, these triggers will be enabled.

Table 12 - 189. Parameters for DBMS_SNAPSHOT.SET_I_AM_A_REFRESH

parameter	description
`value`	Value that you want to set the I_AM_A_REFRESH package state to. If this state is set to TRUE, all local replication triggers for snapshots will be effectively disabled in this session because each replication trigger first checks this state. If this state is set to FALSE, these triggers will be enabled.