Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Replication Overview

Creating a Replicated Environment Overview

Before You Start

Global Names

Job Processes

2 Create Replication Site

Overview of Setting Up Replication Sites

Set Up Master Sites

Set Up Snapshot Sites

3 Create a Master Group

Overview of Creating a Master Group

Before You Start

Create Master Group

4 Create Deployment Template

Oracle Deployment Templates Concepts

Build Deployment Template

Package for Instantiation

Package Template

Save Instantiation Script to File

Distribute Files

Instantiate Deployment Template

Refresh After Instantiation

5 Create Snapshot Group

Creating a Snapshot Group Overview

Create Snapshot Group

6 Conflict Resolution

Prepare for Conflict Resolution

Plan

Create Conflict Resolution Methods for Update Conflicts

Overwrite and Discard

Minimum and Maximum

Timestamp

Additive and Average

Priority Groups

Site Priority

Create Conflict Resolution Methods for Uniqueness Conflicts

Create Conflict Avoidance Methods for Delete Conflicts

Audit Successful Conflict Resolution

Gathering Conflict Resolution Statistics

Viewing Conflict Resolution Statistics

Canceling Conflict Resolution Statistics

Deleting Statistics Information

7 Manage Replicated Environment with APIs

Managing Master Sites

Change Master Definition Site

Add a Master Site

Drop a Master Site

Managing Snapshot Sites

Using a Group Owner

Changing a Snapshot Group's Master Site

Dropping Snapshot Sites

Managing Snapshot Logs

Managing Deferred Transactions

Pushing the Deferred Transaction Queue

Purging the Deferred Transaction Queue

Managing the Error Queue

Re-execute Error Transaction as the Receiver

Re-execute Error Transaction as Alternate User

Altering a Replicated Object

Performing an Offline Instantiation Using Export/Import

Master Site

Snapshot Site

Determining Differences Between Replicated Tables

DIFFERENCES

RECTIFY

Updating the Comments Fields in Data Dictionary Views

8 Replication Management API Reference

Packages

Examples of Using Oracle's Replication Management API

Issues to Consider

Replication Manager and Oracle Replication Management API

DBMS_DEFER Package

Summary of Subprograms

CALL procedure

COMMIT_WORK procedure

datatype_ARG procedure

TRANSACTION procedure

DBMS_DEFER_QUERY Package

Summary of Subprograms

GET_ARG_FORM function

GET_ARG_TYPE function

GET_CALL_ARGS procedure

GET_datatype_ARG function

DBMS_DEFER_SYS Package

Summary of Subprograms

ADD_DEFAULT_DEST procedure

DELETE_DEFAULT_DEST procedure

DELETE_DEF_DESTINATION procedure

DELETE_ERROR procedure

DELETE_TRAN procedure

DISABLED function

EXCLUDE_PUSH procedure

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

DBMS_OFFLINE_OG Package

Summary of Subprograms

BEGIN_INSTANTIATION procedure

BEGIN_LOAD procedure

END_INSTANTIATION procedure

END_LOAD procedure

RESUME_SUBSET_OF_MASTERS procedure

DBMS_OFFLINE_SNAPSHOT Package

Summary of Subprograms

BEGIN_LOAD procedure

END_LOAD procedure

DBMS_RECTIFIER_DIFF Package

Summary of Subprograms

DIFFERENCES procedure

RECTIFY procedure

DBMS_REFRESH Package

Summary of Subprograms

ADD procedure

CHANGE procedure

DESTROY procedure

MAKE procedure

REFRESH procedure

SUBTRACT procedure

DBMS_REPCAT Package

Summary of Subprograms

ADD_GROUPED_COLUMN procedure

ADD_MASTER_DATABASE procedure

ADD_PRIORITY_datatype procedure

ADD_SITE_PRIORITY_SITE procedure

ADD_conflicttype_RESOLUTION procedure

ALTER_MASTER_PROPAGATION procedure

ALTER_MASTER_REPOBJECT procedure

ALTER_PRIORITY procedure

ALTER_PRIORITY_datatype procedure

ALTER_SITE_PRIORITY procedure

ALTER_SITE_PRIORITY_SITE procedure

ALTER_SNAPSHOT_PROPAGATION procedure

CANCEL_STATISTICS procedure

COMMENT_ON_COLUMN_GROUP procedure

COMMENT_ON_PRIORITY_GROUP/COMMENT_ON_SITE_PRIORITY procedures

COMMENT_ON_REPGROUP procedure

COMMENT_ON_REPOBJECT procedure

COMMENT_ON_REPSITES procedure

COMMENT_ON_SNAPSHOT_REPSITES procedure

COMMENT_ON_conflicttype_RESOLUTION procedure

COMPARE_OLD_VALUES procedure

CREATE_MASTER_REPGROUP procedure

CREATE_MASTER_REPOBJECT procedure

CREATE_SNAPSHOT_REPGROUP procedure

CREATE_SNAPSHOT_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_PRIORITY procedure

DROP_PRIORITY_GROUP procedure

DROP_PRIORITY_datatype procedure

DROP_SITE_PRIORITY procedure

DROP_SITE_PRIORITY_SITE procedure

DROP_SNAPSHOT_REPGROUP procedure

DROP_SNAPSHOT_REPOBJECT procedure

DROP_conflicttype_RESOLUTION procedure

EXECUTE_DDL procedure

GENERATE_REPLICATION_SUPPORT procedure

GENERATE_SNAPSHOT_SUPPORT procedure

MAKE_COLUMN_GROUP procedure

PURGE_MASTER_LOG procedure

PURGE_STATISTICS procedure

REFRESH_SNAPSHOT_REPGROUP procedure

REGISTER_SNAPSHOT_REPGROUP procedure

REGISTER_STATISTICS procedure

RELOCATE_MASTERDEF procedure

REMOVE_MASTER_DATABASES procedure

REPCAT_IMPORT_CHECK procedure

RESUME_MASTER_ACTIVITY procedure

SEND_OLD_VALUES procedure

SET_COLUMNS procedure

SUSPEND_MASTER_ACTIVITY procedure

SWITCH_SNAPSHOT_MASTER procedure

UNREGISTER_SNAPSHOT_REPGROUP procedure

VALIDATE function

WAIT_MASTER_LOG procedure

DBMS_REPCAT_ADMIN Package

Summary of 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

DBMS_REPCAT_INSTANTIATE Package

Summary of Subprograms

DROP_SITE_INSTANTIATION procedure

INSTANTIATE_OFFLINE function

INSTANTIATE_OFFLINE_REPAPI function

INSTANTIATE_ONLINE function

DBMS_REPCAT_RGT Package

Summary of 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_OFFLINE_REPAPI function

INSTANTIATE_ONLINE function

LOCK_TEMPLATE_EXCLUSIVE procedure

LOCK_TEMPLATE_SHARED procedure

DBMS_REPUTIL Package

Summary of 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

DBMS_SNAPSHOT Package

Summary of Subprograms

BEGIN_TABLE_REORGANIZATION procedure

END_TABLE_REORGANIZATION procedure

I_AM_A_REFRESH function

PURGE_DIRECT_LOAD_LOG procedure

PURGE_LOG procedure

PURGE_SNAPSHOT_FROM_LOG procedure

REFRESH procedure

REFRESH_ALL_MVIEWS procedure

REFRESH_DEPENDENT procedure

REGISTER_SNAPSHOT procedure

UNREGISTER_SNAPSHOT procedure

9 Data Dictionary Views

Replication Catalog Views

ALL_REPCATLOG

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_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_REPCATLOG

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_REPCOLUMN

DBA_REPCOLUMN_GROUP

DBA_REPCONFLICT

DBA_REPDDL

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

USER_REPCATLOG

USER_REPCAT_REFRESH_TEMPLATES

USER_REPCAT_TEMPLATE_OBJECTS

USER_REPCAT_TEMPLATE_PARMS

USER_REPCAT_TEMPLATE_SITES

USER_REPCAT_USER_AUTHORIZATIONS

USER_REPCAT_USER_PARM_VALUES

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

Deferred Transaction Views

DEFCALL

DEFCALLDEST

DEFDEFAULTDEST

DEFERRCOUNT

DEFERROR

DEFLOB

DEFPROPAGATOR

DEFSCHEDULE

DEFTRAN

DEFTRANDEST

Snapshots and Snapshot Refresh Group Views

ALL_REFRESH

ALL_REFRESH_CHILDREN

ALL_REGISTERED_SNAPSHOTS

ALL_SNAPSHOT_LOGS

ALL_SNAPSHOT_REFRESH_TIMES

ALL_SNAPSHOTS

DBA_REFRESH

DBA_REFRESH_CHILDREN

DBA_REGISTERED_SNAPSHOT_GROUPS

DBA_REGISTERED_SNAPSHOTS

DBA_SNAPSHOT_LOGS

DBA_SNAPSHOT_LOG_FILTER_COLS

DBA_SNAPSHOT_REFRESH_TIMES

DBA_SNAPSHOTS

USER_REFRESH

USER_REFRESH_CHILDREN

USER_REGISTERED_SNAPSHOTS

USER_SNAPSHOTS

USER_SNAPSHOT_LOGS

USER_SNAPSHOT_REFRESH_TIMES

A Security Options

Security Setup for Multimaster Replication

Trusted vs. Untrusted Security

Security Setup for Snapshot Replication

Trusted vs. 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

Restrictions

Example User-Defined Conflict Resolution Method

User-Defined Conflict Notification Methods

Creating a Conflict Notification Log

Creating a Conflict Notification Package

Viewing Conflict Resolution Information

Index