Oracle in a Nutshell

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