Skip Headers
Oracle® Database Advanced Replication Management API Reference
11g Release 1 (11.1)
Part Number B28327-02
Home
Book List
Index
Master Index
Contact Us
Next
View PDF
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
Part I Configuring Your Replication Environment
1
Overview of Advanced Replication
Overview of Creating a Replication Environment
Before You Start
2
Configuring the Replication Sites
Overview of Setting Up Replication Sites
Setting Up Master Sites
Setting Up orc1.world
Setting Up orc2.world
Setting Up orc3.world
Creating Scheduled Links Between the Master Sites
Setting Up Materialized View Sites
Setting Up mv1.world
Setting Up mv2.world
3
Creating a Master Group
Overview of Creating a Master Group
Before You Start
Creating a Master Group
4
Creating a Deployment Template
Oracle Deployment Templates Concepts
Before Creating the Deployment Template
Creating a Deployment Template
Packaging a Deployment Template for Instantiation
Packaging a Deployment Template
Packaging a Deployment Template for Offline Instantiation
Packaging a Deployment Template for Online Instantiation
Saving an Instantiation Script to File
Distributing Instantiation Files
Instantiating a Deployment Template
Refreshing a Refresh Group After Instantiation
5
Creating a Materialized View Group
Overview of Creating a Materialized View Group
Creating a Materialized View Group
Creating the Materialized View Group at mv1.world
Creating the Materialized View Group at mv2.world
6
Configuring Conflict Resolution
Preparing for Conflict Resolution
Creating Conflict Resolution Methods for Update Conflicts
Overwrite and Discard Conflict Resolution Methods
Minimum and Maximum Conflict Resolution Methods
Timestamp Conflict Resolution Methods
Additive and Average Conflict Resolution Methods
Priority Groups Conflict Resolution Methods
Site Priority Conflict Resolution Methods
Creating Conflict Resolution Methods for Uniqueness Conflicts
Creating Conflict Avoidance Methods for Delete Conflicts
Using Dynamic Ownership Conflict Avoidance
Workflow
Token Passing
Locating the Owner of a Row
Obtaining Ownership
Applying the Change
Auditing Successful Conflict Resolution
Collecting Conflict Resolution Statistics
Viewing Conflict Resolution Statistics
Canceling Conflict Resolution Statistics
Clearing Statistics Information
Part II Managing and Monitoring Your Replication Environment
7
Managing a Master Replication Environment
Changing the Master Definition Site
Option 1: All Master Sites Are Available
Option 2: The Old Master Definition Site Is Not Available
Adding New Master Sites
Adding New Master Sites Without Quiescing the Master Group
Using Full Database Export/Import or Change-Based Recovery
Using Object-Level Export/Import
Adding New Master Sites to a Quiesced Master Group
Adding New Master Sites Using the ADD_MASTER_DATABASE Procedure
Adding New Master Sites with Offline Instantiation Using Export/Import
Removing a Master Site from a Master Group
Removing an Unavailable Master Site
Updating the Comments Fields in Data Dictionary Views
Using Procedural Replication
Restrictions on Procedural Replication
User-Defined Types and Procedural Replication
Serializing Transactions
Generating Support for Replicated Procedures
8
Managing a Materialized View Replication Environment
Refreshing Materialized Views
Changing a Materialized View Group's Master Site
Dropping Materialized View Groups and Objects
Dropping a Materialized View Group Created with a Deployment Template
Using the Public Version of DROP_SITE_INSTANTIATION
Using the Private Version of DROP_SITE_INSTANTIATION
Dropping a Materialized View Group or Objects Created Manually
Dropping a Materialized View Group Created Manually
Dropping Objects at a Materialized View Site
Cleaning Up a Master Site or Master Materialized View Site
Cleaning Up After Dropping a Materialized View Group
Cleaning Up Individual Materialized View Support
Managing Materialized View Logs
Altering Materialized View Logs
Altering Materialized View Log Storage Parameters
Altering a Materialized View Log to Add Columns
Managing Materialized View Log Space
Purging Rows from a Materialized View Log
Truncating a Materialized View Log
Reorganizing Master Tables that Have Materialized View Logs
Reorganization Notification
Truncating Masters
Methods of Reorganizing a Database Table
Dropping a Materialized View Log
Performing an Offline Instantiation of a Materialized View Site Using Export/Import
Using a Group Owner for a Materialized View Group
9
Managing Replication Objects and Queues
Altering a Replicated Object in a Quiesced Master Group
Modifying Tables without Replicating the Modifications
Disabling Replication
Reenabling Replication
Ensuring that Replicated Triggers Fire Only Once
Converting a LONG Column to a LOB Column in a Replicated Table
Determining Differences Between Replicated Tables
Using the DIFFERENCES Procedure
Using the RECTIFY Procedure
Managing the Deferred Transactions Queue
Pushing the Deferred Transaction Queue
Purging the Deferred Transaction Queue
Using the ANYDATA Type to Determine the Value of an Argument in a Deferred Call
Managing the Error Queue
Reexecuting Error Transaction as the Receiver
Reexecuting Error Transaction as Alternate User
10
Monitoring a Replication Environment
Monitoring Master Replication Environments
Monitoring Master Sites
Listing General Information About a Master Site
Monitoring Master Groups
Listing the Master Sites Participating in a Master Group
Listing General Information About Master Groups
Monitoring Masters
Listing Information About Materialized Views Based on a Master
Listing Information About the Materialized View Logs at a Master
Listing the Materialized Views that Use a Materialized View Log
Listing Information About the Deployment Templates at a Master
Monitoring Materialized View Sites
Listing General Information About a Materialized View Site
Listing General Information About Materialized View Groups
Listing Information About Materialized Views
Listing Master Information For Materialized Views
Listing the Properties of Materialized Views
Listing Information About the Refresh Groups at a Materialized View Site
Determining the Job ID for Each Refresh Job at a Materialized View Site
Determining Which Materialized Views Are Currently Refreshing
Monitoring Administrative Requests
Listing General Information About Administrative Requests
Determining the Cause of Administrative Request Errors
Listing General Information About the Job that Executes Administrative Requests
Checking the Definition of Each do_deferred_repcat_admin Job
Monitoring the Deferred Transactions Queue
Monitoring Transaction Propagation
Listing the Number of Deferred Transactions for Each Destination Master Site
Listing General Information About the Push Jobs at a Replication Site
Determining the Next Start Time and Interval for the Push Jobs
Determining the Total Number of Transactions Queued for Propagation
Monitoring Purges of Successfully Propagated Transactions
Listing General Information About the Purge Job
Checking the Definition of the Purge Job
Determining the Amount of Time Since the Last Purge
Determining the Total Number of Purged Transactions
Monitoring the Error Queue
Listing General Information About the Error Transactions at a Replication Site
Determining the Percentage of Error Transactions
Listing the Number of Error Transactions from Each Origin Master Site
Listing the Error Messages for the Error Transactions at a Replication Site
Determining the Error Operations at a Replication Site
Monitoring Performance in a Replication Environment
Tracking the Average Number of Row Changes in a Replication Transaction
Tracking the Rate of Transactions Entering the Deferred Transactions Queue
Determining the Average Network Traffic Created to Propagate a Transaction
Determining the Average Amount of Time to Apply Transactions at Remote Sites
Determining the Percentage of Time the Parallel Propagation Job Spends Sleeping
Clearing the Statistics for a Remote Master Site in the DEFSCHEDULE View
Monitoring Parallel Propagation of Deferred Transactions Using V$REPLPROP
Determining the Databases to Which You Are Propagating Deferred Transactions
Determining the Transactions Currently Being Propagated to a Remote Master
Part III Replication Management API Packages Reference
11
Introduction to the Replication Management API Reference
Examples of Using Oracle's Replication Management API
Issues to Consider When Using the Replication Management API
The Advanced Replication Interface and the Replication Management API
Abbreviations for Datetime and Interval Data Types
12
DBMS_DEFER
Summary of DBMS_DEFER Subprograms
CALL Procedure
COMMIT_WORK Procedure
datatype
_ARG Procedure
TRANSACTION Procedure
13
DBMS_DEFER_QUERY
Summary of DBMS_DEFER_QUERY Subprograms
GET_ARG_FORM Function
GET_ARG_TYPE Function
GET_CALL_ARGS Procedure
GET_
datatype
_ARG Function
GET_OBJECT_NULL_VECTOR_ARG Function
14
DBMS_DEFER_SYS
Summary of DBMS_DEFER_SYS Subprograms
ADD_DEFAULT_DEST Procedure
CLEAR_PROP_STATISTICS Procedure
DELETE_DEFAULT_DEST Procedure
DELETE_DEF_DESTINATION Procedure
DELETE_ERROR Procedure
DELETE_TRAN Procedure
DISABLED Function
EXCLUDE_PUSH Function
EXECUTE_ERROR Procedure
EXECUTE_ERROR_AS_USER Procedure
PURGE Function
PUSH Function
REGISTER_PROPAGATOR Procedure
SCHEDULE_PURGE Procedure
SCHEDULE_PUSH Procedure
SET_DISABLED Procedure
UNREGISTER_PROPAGATOR Procedure
UNSCHEDULE_PURGE Procedure
UNSCHEDULE_PUSH Procedure
15
DBMS_OFFLINE_OG
Summary of DBMS_OFFLINE_OG Subprograms
BEGIN_INSTANTIATION Procedure
BEGIN_LOAD Procedure
END_INSTANTIATION Procedure
END_LOAD Procedure
RESUME_SUBSET_OF_MASTERS Procedure
16
DBMS_RECTIFIER_DIFF
Summary of DBMS_RECTIFIER_DIFF Subprograms
DIFFERENCES Procedure
RECTIFY Procedure
17
DBMS_REFRESH
Summary of DBMS_REFRESH Subprograms
ADD Procedure
CHANGE Procedure
DESTROY Procedure
MAKE Procedure
REFRESH Procedure
SUBTRACT Procedure
18
DBMS_REPCAT
Summary of DBMS_REPCAT Subprograms
ADD_GROUPED_COLUMN Procedure
ADD_MASTER_DATABASE Procedure
ADD_NEW_MASTERS Procedure
ADD_PRIORITY_
datatype
Procedure
ADD_SITE_PRIORITY_SITE Procedure
ADD_
conflicttype
_RESOLUTION Procedure
ALTER_CATCHUP_PARAMETERS Procedure
ALTER_MASTER_PROPAGATION Procedure
ALTER_MASTER_REPOBJECT Procedure
ALTER_MVIEW_PROPAGATION Procedure
ALTER_PRIORITY Procedure
ALTER_PRIORITY_
datatype
Procedure
ALTER_SITE_PRIORITY Procedure
ALTER_SITE_PRIORITY_SITE Procedure
CANCEL_STATISTICS Procedure
COMMENT_ON_COLUMN_GROUP Procedure
COMMENT_ON_MVIEW_REPSITES Procedure
COMMENT_ON_PRIORITY_GROUP Procedures
COMMENT_ON_REPGROUP Procedure
COMMENT_ON_REPOBJECT Procedure
COMMENT_ON_REPSITES Procedure
COMMENT_ON_SITE_PRIORITY Procedure
COMMENT_ON_
conflicttype
_RESOLUTION Procedure
COMPARE_OLD_VALUES Procedure
CREATE_MASTER_REPGROUP Procedure
CREATE_MASTER_REPOBJECT Procedure
CREATE_MVIEW_REPGROUP Procedure
CREATE_MVIEW_REPOBJECT Procedure
DEFINE_COLUMN_GROUP Procedure
DEFINE_PRIORITY_GROUP Procedure
DEFINE_SITE_PRIORITY Procedure
DO_DEFERRED_REPCAT_ADMIN Procedure
DROP_COLUMN_GROUP Procedure
DROP_GROUPED_COLUMN Procedure
DROP_MASTER_REPGROUP Procedure
DROP_MASTER_REPOBJECT Procedure
DROP_MVIEW_REPGROUP Procedure
DROP_MVIEW_REPOBJECT Procedure
DROP_PRIORITY Procedure
DROP_PRIORITY_GROUP Procedure
DROP_PRIORITY_
datatype
Procedure
DROP_SITE_PRIORITY Procedure
DROP_SITE_PRIORITY_SITE Procedure
DROP_
conflicttype
_RESOLUTION Procedure
EXECUTE_DDL Procedure
GENERATE_MVIEW_SUPPORT Procedure
GENERATE_REPLICATION_SUPPORT Procedure
MAKE_COLUMN_GROUP Procedure
PREPARE_INSTANTIATED_MASTER Procedure
PURGE_MASTER_LOG Procedure
PURGE_STATISTICS Procedure
REFRESH_MVIEW_REPGROUP Procedure
REGISTER_MVIEW_REPGROUP Procedure
REGISTER_STATISTICS Procedure
RELOCATE_MASTERDEF Procedure
REMOVE_MASTER_DATABASES Procedure
RENAME_SHADOW_COLUMN_GROUP Procedure
REPCAT_IMPORT_CHECK Procedure
RESUME_MASTER_ACTIVITY Procedure
RESUME_PROPAGATION_TO_MDEF Procedure
SEND_OLD_VALUES Procedure
SET_COLUMNS Procedure
SPECIFY_NEW_MASTERS Procedure
STREAMS_MIGRATION Procedure
SUSPEND_MASTER_ACTIVITY Procedure
SWITCH_MVIEW_MASTER Procedure
UNDO_ADD_NEW_MASTERS_REQUEST Procedure
UNREGISTER_MVIEW_REPGROUP Procedure
VALIDATE Function
WAIT_MASTER_LOG Procedure
19
DBMS_REPCAT_INSTANTIATE
Summary of DBMS_REPCAT_INSTANTIATE Subprograms
DROP_SITE_INSTANTIATION Procedure
INSTANTIATE_OFFLINE Function
INSTANTIATE_ONLINE Function
20
DBMS_REPCAT_ADMIN
Summary of DBMS_REPCAT_ADMIN Subprograms
GRANT_ADMIN_ANY_SCHEMA Procedure
GRANT_ADMIN_SCHEMA Procedure
REGISTER_USER_REPGROUP Procedure
REVOKE_ADMIN_ANY_SCHEMA Procedure
REVOKE_ADMIN_SCHEMA Procedure
UNREGISTER_USER_REPGROUP Procedure
21
DBMS_REPCAT_RGT
Summary of DBMS_REPCAT_RGT Subprograms
ALTER_REFRESH_TEMPLATE Procedure
ALTER_TEMPLATE_OBJECT Procedure
ALTER_TEMPLATE_PARM Procedure
ALTER_USER_AUTHORIZATION Procedure
ALTER_USER_PARM_VALUE Procedure
COMPARE_TEMPLATES Function
COPY_TEMPLATE Function
CREATE_OBJECT_FROM_EXISTING Function
CREATE_REFRESH_TEMPLATE Function
CREATE_TEMPLATE_OBJECT Function
CREATE_TEMPLATE_PARM Function
CREATE_USER_AUTHORIZATION Function
CREATE_USER_PARM_VALUE Function
DELETE_RUNTIME_PARMS Procedure
DROP_ALL_OBJECTS Procedure
DROP_ALL_TEMPLATE_PARMS Procedure
DROP_ALL_TEMPLATE_SITES Procedure
DROP_ALL_TEMPLATES Procedure
DROP_ALL_USER_AUTHORIZATIONS Procedure
DROP_ALL_USER_PARM_VALUES Procedure
DROP_REFRESH_TEMPLATE Procedure
DROP_SITE_INSTANTIATION Procedure
DROP_TEMPLATE_OBJECT Procedure
DROP_TEMPLATE_PARM Procedure
DROP_USER_AUTHORIZATION Procedure
DROP_USER_PARM_VALUE Procedure
GET_RUNTIME_PARM_ID Function
INSERT_RUNTIME_PARMS Procedure
INSTANTIATE_OFFLINE Function
INSTANTIATE_ONLINE Function
LOCK_TEMPLATE_EXCLUSIVE Procedure
LOCK_TEMPLATE_SHARED Procedure
22
DBMS_REPUTIL
Summary of DBMS_REPUTIL Subprograms
REPLICATION_OFF Procedure
REPLICATION_ON Procedure
REPLICATION_IS_ON Function
FROM_REMOTE Function
GLOBAL_NAME Function
MAKE_INTERNAL_PKG Procedure
SYNC_UP_REP Procedure
Part IV Replication Data Dictionary Reference
23
Replication Catalog Views
Summary of Replication Catalog Views
DBA_REGISTERED_MVIEW_GROUPS
ALL_REPCAT_REFRESH_TEMPLATES
ALL_REPCAT_TEMPLATE_OBJECTS
ALL_REPCAT_TEMPLATE_PARMS
ALL_REPCAT_TEMPLATE_SITES
ALL_REPCAT_USER_AUTHORIZATIONS
ALL_REPCAT_USER_PARM_VALUES
ALL_REPCATLOG
ALL_REPCOLUMN
ALL_REPCOLUMN_GROUP
ALL_REPCONFLICT
ALL_REPDDL
ALL_REPGENOBJECTS
ALL_REPGROUP
ALL_REPGROUP_PRIVILEGES
ALL_REPGROUPED_COLUMN
ALL_REPKEY_COLUMNS
ALL_REPOBJECT
ALL_REPPARAMETER_COLUMN
ALL_REPPRIORITY
ALL_REPPRIORITY_GROUP
ALL_REPPROP
ALL_REPRESOL_STATS_CONTROL
ALL_REPRESOLUTION
ALL_REPRESOLUTION_METHOD
ALL_REPRESOLUTION_STATISTICS
ALL_REPSITES
DBA_REPCAT_REFRESH_TEMPLATES
DBA_REPCAT_TEMPLATE_OBJECTS
DBA_REPCAT_TEMPLATE_PARMS
DBA_REPCAT_TEMPLATE_SITES
DBA_REPCAT_USER_AUTHORIZATIONS
DBA_REPCAT_USER_PARM_VALUES
DBA_REPCATLOG
DBA_REPCOLUMN
DBA_REPCOLUMN_GROUP
DBA_REPCONFLICT
DBA_REPDDL
DBA_REPEXTENSIONS
DBA_REPGENOBJECTS
DBA_REPGROUP
DBA_REPGROUP_PRIVILEGES
DBA_REPGROUPED_COLUMN
DBA_REPKEY_COLUMNS
DBA_REPOBJECT
DBA_REPPARAMETER_COLUMN
DBA_REPPRIORITY
DBA_REPPRIORITY_GROUP
DBA_REPPROP
DBA_REPRESOL_STATS_CONTROL
DBA_REPRESOLUTION
DBA_REPRESOLUTION_METHOD
DBA_REPRESOLUTION_STATISTICS
DBA_REPSITES
DBA_REPSITES_NEW
USER_REPCAT_REFRESH_TEMPLATES
USER_REPCAT_TEMPLATE_OBJECTS
USER_REPCAT_TEMPLATE_PARMS
USER_REPCAT_TEMPLATE_SITES
USER_REPCAT_USER_AUTHORIZATION
USER_REPCAT_USER_PARM_VALUES
USER_REPCATLOG
USER_REPCOLUMN
USER_REPCOLUMN_GROUP
USER_REPCONFLICT
USER_REPDDL
USER_REPGENOBJECTS
USER_REPGROUP
USER_REPGROUP_PRIVILEGES
USER_REPGROUPED_COLUMN
USER_REPKEY_COLUMNS
USER_REPOBJECT
USER_REPPARAMETER_COLUMN
USER_REPPRIORITY
USER_REPPRIORITY_GROUP
USER_REPPROP
USER_REPRESOL_STATS_CONTROL
USER_REPRESOLUTION
USER_REPRESOLUTION_METHOD
USER_REPRESOLUTION_STATISTICS
USER_REPSITES
24
Replication Dynamic Performance Views
V$MVREFRESH
V$REPLPROP
V$REPLQUEUE
25
Deferred Transaction Views
DEFCALL
DEFCALLDEST
DEFDEFAULTDEST
DEFERRCOUNT
DEFERROR
DEFLOB
DEFPROPAGATOR
DEFSCHEDULE
DEFTRAN
DEFTRANDEST
26
Materialized View and Refresh Group Views
Part V Appendixes
A
Security Options
Security Setup for Multimaster Replication
Trusted Compared with Untrusted Security
Security Setup for Materialized View Replication
Trusted Compared with Untrusted Security
B
User-Defined Conflict Resolution Methods
User-Defined Conflict Resolution Methods
Conflict Resolution Method Parameters
Resolving Update Conflicts
Resolving Uniqueness Conflicts
Resolving Delete Conflicts
Multitier Materialized Views and User-Defined Conflict Resolution Methods
Restrictions for User-Defined Conflict Resolution Methods
SQL Statement Restrictions for User-Defined Conflict Resolution Methods
Column Subsetting Restrictions for User-Defined Conflict Resolution Methods
Examples of User-Defined Conflict Resolution Method
Maximum User Function
Additive User Function
User-Defined Conflict Notification Methods
Creating a Conflict Notification Log
Sample Conflict Notification Log Table
Creating a Conflict Notification Package
Sample Conflict Notification Package
Viewing Conflict Resolution Information
Index