Replication Management API Reference, 14 of 179

DBMS_DEFER_SYS Package

Summary of Subprograms

Table 8-21 DBMS_DEFER_SYS Package Subprograms (Page 1 of 2)

Subprogram	Description
ADD_DEFAULT_DEST procedure	Adds a destination database to the `DEFDEFAULTDEST` view.
DELETE_DEFAULT_DEST procedure	Removes a destination database from the `DEFDEFAULTDEST` view.
DELETE_DEF_DESTINATION procedure	Removes a destination database from the `DEFSCHEDULE` view.
DELETE_ERROR procedure	Deletes a transaction from the `DEFERROR` view.
DELETE_TRAN procedure	Deletes a transaction from the `DEFTRANDEST` view.
DISABLED function	Determines whether propagation of the deferred transaction queue from the current site to a specified site is enabled.
EXCLUDE_PUSH procedure	Acquires an exclusive lock that prevents deferred transaction `PUSH`.
EXECUTE_ERROR procedure	Re-executes a deferred transaction that did not initially complete successfully in the security context of the original receiver of the transaction.
EXECUTE_ERROR_AS_USER procedure	Re-executes a deferred transaction that did not initially complete successfully in the security context of the user who executes this procedure.
PURGE function	Purges pushed transactions from the deferred transaction queue at your current master or snapshot site.
PUSH function	Forces a deferred remote procedure call queue at your current master or snapshot site to be pushed to another master site.
REGISTER_PROPAGATOR procedure	Registers the specified user as the propagator for the local database.
SCHEDULE_PURGE procedure	Schedules a job to purge pushed transactions from the deferred transaction queue at your current master or snapshot site.
SCHEDULE_PUSH procedure	Schedules a job to push the deferred transaction queue to a remote master destination.
SET_DISABLED procedure	Disables or enables propagation of the deferred transaction queue from the current site to a specified destination site.
UNREGISTER_PROPAGATOR procedure	Unregisters a user as the propagator from the local database.
UNSCHEDULE_PURGE procedure	Stops automatic purges of pushed transactions from the deferred transaction queue at a snapshot or master site.
UNSCHEDULE_PUSH procedure	Stops automatic pushes of the deferred transaction queue from a snapshot or master site to another master site.