Calls
-
PROCEDURE DBMS_DEFER_SYS.ADD_DEFAULT_DEST(dblinkIN VARCHAR2); Adds the fully qualified database name (dblink) to the DEFDEFAULTDEST data dictionary view.
-
PROCEDURE DBMS_DEFER_SYS.CLEAR_PROP_STATISTICS(dblinkIN VARCHAR2); Clears propagation statistics for dblink from the DEFSCHEDULE data dictionary view. New with Oracle9i.
-
PROCEDURE DBMS_DEFER_SYS.DELETE_DEFAULT_DEST(dblinkIN VARCHAR2); Removes the dblink database from the DEFDEFAULTDEST data dictionary view.
-
PROCEDURE DBMS_DEFER_SYS.DELETE_DEF_DESTINATION(destinationIN VARCHAR2,forceIN 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_idIN VARCHAR2,destinationIN VARCHAR2); Deletes deferred_tran_id in destination from the DEFERROR data dictionary view.
-
PROCEDURE DBMS_DEFER_SYS.DELETE_TRAN(deferred_tran_idIN VARCHAR2,destinationIN VARCHAR2); Deletes deferred_tran_id in destination from the DEFTRANDEST data dictionary view.
-
FUNCTION DBMS_DEFER_SYS.DISABLED(destinationIN VARCHAR2)RETURN BOOLEAN; Returns if propagation from current site to destination is enabled.
-
FUNCTION DBMS_DEFER_SYS.EXCLUDE_PUSH(timeoutIN 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_idIN VARCHAR2, ...