O'Reilly logo

Oracle in a Nutshell by David C. Kreines, Rick Greenwald

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

Calls

PROCEDURE DBMS_DEFER_SYS.ADD_DEFAULT_DEST (dblink IN VARCHAR2);

Adds the fully qualified database name (dblink) to the DEFDEFAULTDEST data dictionary view.

PROCEDURE DBMS_DEFER_SYS.CLEAR_PROP_STATISTICS (dblink IN VARCHAR2);

Clears propagation statistics for dblink from the DEFSCHEDULE data dictionary view. New with Oracle9i.

PROCEDURE DBMS_DEFER_SYS.DELETE_DEFAULT_DEST (dblink IN VARCHAR2);

Removes the dblink database from the DEFDEFAULTDEST data dictionary view.

PROCEDURE DBMS_DEFER_SYS.DELETE_DEF_DESTINATION (destination IN VARCHAR2, force IN BOOLEAN := FALSE);

Removes the destination database from the DEFSCHEDULE view. If force is TRUE, Oracle ignores all safety checks and deletes the destination.

PROCEDURE DBMS_DEFER_SYS.DELETE_ERROR (deferred_tran_id IN VARCHAR2, destination IN VARCHAR2);

Deletes deferred_tran_id in destination from the DEFERROR data dictionary view.

PROCEDURE DBMS_DEFER_SYS.DELETE_TRAN (deferred_tran_id IN VARCHAR2, destination IN VARCHAR2);

Deletes deferred_tran_id in destination from the DEFTRANDEST data dictionary view.

FUNCTION DBMS_DEFER_SYS.DISABLED (destination IN VARCHAR2) RETURN BOOLEAN;

Returns if propagation from current site to destination is enabled.

FUNCTION DBMS_DEFER_SYS.EXCLUDE_PUSH (timeout IN INTEGER) RETURN INTEGER;

Prevents deferred transaction PUSHes for the duration of the transaction. If lock to prevent PUSHes cannot be acquired in timeout seconds, returns 1.

PROCEDURE DBMS_DEFER_SYS.EXECUTE_ERROR (deferred_tran_id IN VARCHAR2, ...

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