Oracle® Database Advanced Replication Management API Reference 10g Release 1 (10.1) Part Number B10733-01 |
|
|
View PDF |
To disable or enable propagation of the deferred transaction queue from the current site to a specified destination site. If the disabled parameter is true
, then the procedure disables propagation to the specified destination and future invocations of PUSH
do not push the deferred remote procedure call (RPC) queue. SET_DISABLED
eventually affects a session already pushing the queue to the specified destination, but does not affect sessions appending to the queue with DBMS_DEFER
.
If the disabled parameter is false
, then the procedure enables propagation to the specified destination and, although this does not push the queue, it permits future invocations of PUSH
to push the queue to the specified destination. Whether the disabled parameter is true
or false
, a COMMIT
is required for the setting to take effect in other sessions.
DBMS_DEFER_SYS.SET_DISABLED ( destination IN VARCHAR2, disabled IN BOOLEAN := true, catchup IN RAW := '00', override IN BOOLEAN := false);