O'Reilly logo

Oracle Built-in Packages by John Beresniewicz, Charles Dye, Steven Feuerstein

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required