PL/SQL Packages DBMS_DEFER_SYS

Manage default replication node lists. Requires the Distributed Option.

Subprocedures and functions:

ADD_DEFAULT_DEST       Add a destination database to the DEFDEFAULTDEST view. 

CLEAR_PROP_STATISTICS  Clear the propagation statistics in the DEFSCHEDULE data dictionary view. 

DELETE_DEFAULT_DEST    Remove a destination database from the DEFDEFAULTDEST view. 

DELETE_DEF_DESTINATION Remove a destination database from the DEFSCHEDULE view. 

DELETE_ERROR           Delete a transaction from the DEFERROR view. 

DELETE_TRAN            Delete a transaction from the DEFTRANDEST view.  

DISABLED Function      Determine whether propagation of the deferred transaction queue from the current site to a specified site is enabled.  

EXCLUDE_PUSH Function  Acquire an exclusive lock that prevents deferred transaction PUSH. 

EXECUTE_ERROR          Reexecute a deferred transaction that did not initially complete successfully in the security context of the original receiver of the transaction. 

EXECUTE_ERROR_AS_USER  Reexecute a deferred transaction that did not initially complete successfully in the security context of the user who executes this procedure. 

PURGE Function         Purge pushed transactions from the deferred transaction queue at your current master site or materialized view site. 

PUSH Function          Force a deferred remote procedure call queue at your current master site or materialized view site to be pushed to a remote site. 

REGISTER_PROPAGATOR    Register the specified user as the propagator for the local database.  

SCHEDULE_PURGE         Schedule a job to purge pushed transactions from the deferred transaction queue at your current master site or materialized view site.  

SCHEDULE_PUSH          Schedule a job to push the deferred transaction queue to a remote site. 

SET_DISABLED           Disable or enables propagation of the deferred transaction queue from the current site to a specified destination site. 

UNREGISTER_PROPAGATOR  Unregister a user as the propagator from the local database. 

UNSCHEDULE_PURGE       Stop automatic purges of pushed transactions from the deferred transaction queue at a master site or materialized view site. 

UNSCHEDULE_PUSH        Stop automatic pushes of the deferred transaction queue from a master site or materialized view site to a remote site.    

For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"

or the book Oracle Built in Packages by Steven Feuerstein et al
Related
:



 
Copyright © 1999-2024 SS64.com
Some rights reserved