12
DBMS_DEFER_SYS

DBMS_DEFER_SYS procedures manage default replication node lists. This package is the system administrator interface to a replicated transactional deferred remote procedure call facility. Administrators and replication daemons can execute transactions queued for remote nodes using this facility, and administrators can control the nodes to which remote calls are destined.

This chapter discusses the following topics:

• Summary of DBMS_DEFER_SYS Subprograms

Summary of DBMS_DEFER_SYS Subprograms

Table 12-1 DBMS_DEFER_SYS Package Subprograms (Page 1 of 2)

Subprogram	Description
"ADD_DEFAULT_DEST Procedure"	Adds a destination database to the DEFDEFAULTDEST view.
"CLEAR_PROP_STATISTICS Procedure"	Clears the propagation statistics in the DEFSCHEDULE data dictionary 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 Function"	Acquires an exclusive lock that prevents deferred transaction PUSH.
"EXECUTE_ERROR Procedure"	Reexecutes 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"	Reexecutes 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 site or materialized view site.
"PUSH Function"	Forces a deferred remote procedure call queue at your current master site or materialized view site to be pushed to a remote 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 site or materialized view site.
"SCHEDULE_PUSH Procedure"	Schedules a job to push the deferred transaction queue to a remote site.
"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 master site or materialized view site.
"UNSCHEDULE_PUSH Procedure"	Stops automatic pushes of the deferred transaction queue from a master site or materialized view site to a remote site.