Oracle8i Replication API Reference
Release 8.1.5

A67793-01

Library

Product

Index

Next

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Overview of the Oracle8i Replication API Reference Book
Audience
Knowledge Assumed of the Reader
How The Oracle8i Replication API Reference Book Is Organized
Conventions Used in This Manual
Special Notes
Text of the Manual
Code Examples
Your Comments Are Welcome

1 Replication Overview

Creating a Replicated Environment Overview
Before You Start
Global Names
Job Processes

2 Create Replication Site

Setting Up a Replication Site Overview
Setup Master Site
Setup Snapshot Site

3 Create a Master Group

Creating a Master Group Overview
Before You Start
Create Master Group

4 Create Deployment Template

Oracle Deployment Templates Concepts
Build Deployment Template
Package for Instantiation
Create Instantiation Script
Save Instantiation Script to File
Instantiate Deployment Template

5 Create a Snapshot Group

Creating a Snapshot Group Overview
Create Snapshot Group

6 Conflict Resolution

Prepare for Conflict Resolution
Plan
Create Update Conflict Resolution Methods
Overwrite and Discard
Minimum and Maximum
Timestamp
Additive and Average
Priority Groups
Site Priority
Create Uniqueness Conflict Resolution Methods
Create Delete Conflict Avoidance Methods

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
Pushing the Deferred Transaction Queue
Dropping Snapshot Sites
Managing the Error Queue
Re-execute Error Transaction as the Receiver
Re-execute Error Transaction as Alternate User
Alter Replicated Object
Offline Instantiation
Master Site
Snapshot Site

8 Replication Management API Reference

Packages
Examples of Using Oracle's Replication Management API
Prerequisites 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
DELETE_TRAN
DISABLED
EXCLUDE_PUSH
EXECUTE_ERROR
EXECUTE_ERROR_AS_USER
PURGE
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 procedure
COMMENT_ON_REPGROUP procedure
COMMENT_ON_REPSITES procedure
COMMENT_ON_REPOBJECT 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 procedure
INSTANTIATE_ONLINE procedure
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_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
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
REPGROUP View
REPCATLOG View
REPCAT_REFRESH_TEMPLATES View
REPCAT_TEMPLATE_OBJECTS View
REPCAT_TEMPLATE_PARMS View
REPCAT_TEMPLATE_SITES View
REPCAT_USER_AUTHORIZATIONS View
REPCAT_USER_PARM_VALUES View
REPCOLUMN View
REPCOLUMN_GROUP View
REPCONFLICT View
REPDDL View
REPGROUP_PRIVILEGES View
REPGROUPED_COLUMN View
REPKEY_COLUMNS View
REPOBJECT View
REPPARAMETER_COLUMN View
REPPRIORITY View
REPPRIORITY_GROUP View
REPPROP View
REPRESOLUTION View
REPRESOL_STATS_CONTROL View
REPRESOLUTION_METHOD View
REPRESOLUTION_STATISTICS View
REPSITES View
REPGENOBJECTS View
Deferred Transaction Views
DEFCALL View
DEFCALLDEST View
DEFDEFAULTDEST View
DEFERRCOUNT View
DEFERROR View
DEFLOB View
DEFPROPAGATOR View
DEFSCHEDULE View
DEFTRAN View
DEFTRANDEST View
Snapshots and Snapshot Refresh Group Views
SNAPSHOTS View
REGISTERED_SNAPSHOTS View
SNAPSHOT_LOGS View
SNAPSHOT_REFRESH_TIMES View
REFRESH View
REFRESH_CHILDREN View

Index



Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Index