Oracle8i Replication Management API Reference
Release 2 (8.1.6)

A76958-01

Library

Product

Contents

Index

Prev Next


Preface

This Preface contains the following topics:

The Oracle8i Replication Management API Reference contains information that describes the features and functionality of the Oracle8i and the Oracle8i Enterprise Edition products. Oracle8i and the Oracle8i Enterprise Edition have the same basic features. However, several advanced features are available only with the Enterprise Edition, and some of these are optional. For example, to use partitioning, you must have the Enterprise Edition and the partitioning option.

See Also:

Getting to Know Oracle8i for information about the differences between Oracle8i and the Oracle8i Enterprise Edition and the features and options that are available to you.  

Overview of This Reference

This reference describes the replication management API. This reference assumes that you are familiar with the replication concepts described in Oracle8i Replication.

The emphasis of this reference is to illustrate how the replication management API is used and to serve as a quick reference source for the replication management API.

Information in this reference applies to the Oracle8i server running on all operating systems. Topics include the following:

Audience

This reference is written for database administrators and application developers who develop and maintain Oracle8i replication environments.

This reference assumes you are familiar with relational database concepts, distributed database administration, PL/SQL (if using procedural replication), and the operating system under which you run an Oracle replicated environment.

This reference also assumes that you have read and understand the information in the following documents:

How This Reference Is Organized

This reference contains the following chapters and appendices:

Chapter 1, "Replication Overview"
Provides an overview of process for building a replicated environment with the replication management API. This chapter also contains some prerequisites for building a replicated environment.

Chapter 2, "Create Replication Site"
Describes in detail the process of setting up both a master and snapshot site. Consult this chapter when building a new replicated environment and when adding either a new master or snapshot site to an established replicated environment.

Chapter 3, "Create a Master Group"
Describes how to build a master group for multimaster replication or as a master for a snapshot site. Chapter 3 builds a master group that replicates data between the three master sites that were set up in Chapter 2.

Chapter 4, "Create Deployment Template"
Describes how to build a snapshot environment with deployment templates, which are the most effective method of distributing a snapshot environment to any number of snapshot sites.

Chapter 5, "Create Snapshot Group"
Describes how to build a snapshot environment with snapshot groups. If deployment templates do not meet your requirements, Chapter 5 describes in detail how to build a snapshot environment at the snapshot site.

Chapter 6, "Conflict Resolution"
Describes the conflict resolution methods that can help your data converge at all sites when a data conflict arises.

Chapter 7, "Manage Replicated Environment with APIs"
Describes many of the management tasks that you may need to perform to manage your replicated environment. Topics discussed include master group management, altering replicated objects, offline instantiation, and more.

Chapter 8, "Replication Management API Reference"
Describes the parameters for the packaged procedures and functions used to implement a replicated environment, as well as exceptions these procedures and functions might raise.

Chapter 9, "Data Dictionary Views"
Describes views of interest to users of deferred transactions, read-only snapshots, and the Oracle replication.

Appendix A, "Security Options"
Describes setting up security for multimaster and snapshot replication using the replication management API.

Appendix B, "User-Defined Conflict Resolution Methods"
Describes building user-defined conflict resolution methods and notification functions using the replication management API.

Changes To This Book

The following major change was made to this book:

Conventions Used in This Reference

This reference uses different fonts to represent different types of information.

Special Notes

Special notes alert you to particular information within the body of this reference:


Note:

Indicates special or auxiliary information. 


See Also:

Indicates where to get more information. 


Caution:

Indicates important information about possible damage to your system or your data. 


Text of the Reference

The following sections describe conventions used this reference.

UPPERCASE Characters 

Uppercase text is used to call attention to statement keywords, object names, initialization parameters, and data dictionary views.

For example, "If you create a private rollback segment, the name must be included in the ROLLBACK_SEGMENTS initialization parameter".  

Italicized Characters 

Italicized words within text indicate the definition of a word, book titles, or emphasized words.

An example of a definition is the following: "A database is a collection of data to be treated as a unit. The general purpose of a database is to store and retrieve related information".

An example of a reference to another book is the following: "For more information, see Oracle8i Designing and Tuning for Performance."

An example of an emphasized word is the following: "You must back up your database regularly".  

Code Examples 

SQL, Server Manager line mode, and SQL*Plus commands/statements appear separated from the text of paragraphs in a monospaced font. For example:

INSERT INTO emp (empno, ename) VALUES (1000, 'SMITH'); 

ALTER TABLESPACE users ADD DATAFILE 'users2.ora' SIZE 50K;
 

Example statements may include punctuation, such as commas or quotation marks. All punctuation in example statements is required. All example statements terminate with a semicolon (;). Depending on the application, a semicolon or other terminator may or may not be required to end a statement.

Uppercase words in example statements indicate the keywords within Oracle SQL. When issuing statements, however, keywords are not case sensitive. Lowercase words in example statements indicate words supplied only for the context of the example. For example, lowercase words may indicate the name of a table, column, or file.

 

Your Comments Are Welcome

We value your comments as an Oracle user and reader of our manuals. As we write, revise, and evaluate, your opinions are the most important input we receive. This manual contains a Reader's Comment Form that we encourage you to use to tell us what you like and dislike about this manual or other Oracle manuals. Please mail comments to:

Server Technologies Documentation Manager

Oracle Corporation

500 Oracle Parkway

Redwood City, CA 94065

U.S.A.

Fax - 650.506.7228 Attn: Server Technologies Documentation Manager

You can send comments and suggestions to the Information Development department at the following e-mail address:

infodev@us.oracle.com


Prev Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index