Oracle9i Replication Management API Reference
Release 1 (9.0.1)

Part Number A87502-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to next page

14
DBMS_DEFER_SYS

DBMS_DEFER_SYS procedures manage default replication node lists. This package is the system administrator interface to a replicated transactional deferred remote procedure call facility. Administrators and replication daemons can execute transactions queued for remote nodes using this facility, and administrators can control the nodes to which remote calls are destined.

This chapter discusses the following topics:

Summary of DBMS_DEFER_SYS Subprograms

Table 14-1 DBMS_DEFER_SYS Package Subprograms (Page 1 of 2)
Subprogram  Description 
ADD_DEFAULT_DEST 
Procedure
 

Adds a destination database to the DEFDEFAULTDEST view. 

CLEAR_PROP_STATISTICS 
Procedure
 

Clears the propagation statistics in the DEFSCHEDULE data dictionary view. 

DELETE_DEFAULT_DEST 
Procedure
 

Removes a destination database from the DEFDEFAULTDEST view. 

DELETE_DEF_DESTINATION 
Procedure
 

Removes a destination database from the DEFSCHEDULE view. 

DELETE_ERROR Procedure
 

Deletes a transaction from the DEFERROR view. 

DELETE_TRAN Procedure
 

Deletes a transaction from the DEFTRANDEST view.  

DISABLED Function
 

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

EXCLUDE_PUSH Function
 

Acquires an exclusive lock that prevents deferred transaction PUSH

EXECUTE_ERROR Procedure
 

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

EXECUTE_ERROR_AS_USER 
Procedure
 

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

PURGE Function
 

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

PUSH Function
 

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

REGISTER_PROPAGATOR 
Procedure
 

Registers the specified user as the propagator for the local database.  

SCHEDULE_PURGE 
Procedure
 

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

SCHEDULE_PUSH Procedure
 

Schedules a job to push the deferred transaction queue to a remote site. 

SET_DISABLED Procedure
 

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

UNREGISTER_PROPAGATOR 
Procedure
 

Unregisters a user as the propagator from the local database. 

UNSCHEDULE_PURGE 
Procedure
 

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

UNSCHEDULE_PUSH 
Procedure
 

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


Go to previous page Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback