Oracle Built-in Packages

DBMS_DEFER_SYS: Managing Deferred Transactions

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

Getting Started with DBMS_DEFER_SYS

The DBMS_DEFER_SYS package is created when the Oracle database is installed. The dbmsdefr.sql script (found in the built-in packages source directory, as described in Chapter 1) 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.sql creates 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 programs

Table 17.10 lists the programs available in the DBMS_DEFER_SYS package.

Table 17-10. DBMS_DEFER_SYS Programs

Name	Description	Use in SQL?
ADD_DEFAULT_DEST	Adds a destination to the DEFDEFAULTDEST data dictionary view	No
COPY	Creates a copy of an RPC with a different destination	No
DELETE_DEFAULT_DEST	Deletes a destination from the DEFDEFAULTDEST data dictionary view	No
DELETE_ERROR	Deletes an error from the DEFERROR data dictionary view	No
DELETE_TRAN	Deletes a transaction from the DEFTRANDEST data dictionary view	No
DISABLED	Returns a BOOLEAN indicating whether deferred transactions from the current site to the destination site are disabled	No
EXCLUDE_PUSH	Acquires ...