Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from 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, ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page