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 ...

Get Oracle Built-in Packages now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.