|Oracle8i Replication Management API Reference
Release 2 (8.1.6)
Part Number A76958-01
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.
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.
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:
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:
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 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.
The following major change was made to this book:
This reference uses different fonts to represent different types of information.
Special notes alert you to particular information within the body of this reference:
The following sections describe conventions used this reference.
For example, "If you create a private rollback segment, the name must be included in the ROLLBACK_SEGMENTS initialization parameter".
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".
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.
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
500 Oracle Parkway
Redwood City, CA 94065
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: