Oracle Distributed Systems

DBMS_DEFER_SYS: Managing Deferred Transactions

The DBMS_DEFER_SYS package provides a number of programs for administrative tasks associated with deferred transactions.

How the Package Is Used

This package is used primarily to administer an advanced replication environment. DBAs can use the procedures to execute deferred transactions, to control what nodes are available for them, and to schedule their execution.

Installation and Access

The DBMS_DEFER_SYS package is created when the Oracle database is installed. The dbmsdefr.sqlscript (found in the built-in packages source directory), contains the source code for this package’s specification. This script is called by catrep.sql, which must be run to install the advanced replication packages. The wrapped SQL script prvtrctf.sqlcreates the public synonym DBMS_DEFER_SYS. No EXECUTE privileges are granted on DBMS_DEFER_SYS; only the owner (SYS) and those with the EXECUTE ANY PROCEDURE system privilege may execute the package.

DBMS_DEFER_SYS Procedures

Procedure Name	Description
ADD_DEFAULT_DEST	Adds a destination to the DEFDEFAULTDEST data dictionary view
COPY	Creates a copy of an RPC with a different destination
DELETE_DEFAULT_DEST	Deletes a destination from the DEFDEFAULTDEST data dictionary view
DELETE_ERROR	Deletes an error from the DEFERROR data dictionary view
DELETE_TRAN	Deletes a transaction from the DEFTRANDEST data dictionary view
DISABLED	Returns a Boolean indicating whether deferred transactions from the current site to the destination ...