Oracle8 Replication
Release 8.0






Prev Next


This Preface contains the following topics:

Oracle8 Replication contains information relating to both Oracle8 and the Oracle8 Enterprise Edition. Some features documented in this manual are available only with the Oracle8 Enterprise Edition. Furthermore, some of these features are only available if you have purchased a particular option, such as the Objects Option.

For information about the differences between Oracle8 and the Oracle8 Enterprise Edition, please refer to Getting to Know Oracle8 and the Oracle8 Enterprise Edition. This text describes features common to both products, and features that are only available with the Oracle8 Enterprise Edition or a particular option.

Overview of The Oracle8 Replication Manual

This manual describes Oracle8 Server replication capabilities. To use the synchronous replication facility, you must have installed Oracle's advanced replication option. Basic replication (read-only and updatable snapshots) is standard Oracle distributed functionality. Procedural replication requires PL/SQL and the advanced replication option.

Information in this manual applies to the Oracle8 Server running on all operating systems.Topics include the following:


This manual is written for application developers and database administrators who develop and maintain advanced Oracle8 distributed systems.

Knowledge Assumed of the Reader

This manual 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 manual also assumes that you have read and understand the information in the following documents:

How The Oracle8 Replication Manual Is Organized

This manual contains 10 chapters and two appendices as described below.

Chapter 1, "Understanding Replication"
Introduces the concepts and terminology of Oracle replication.

Chapter 2, "Using Basic Replication"
Explains how to use read-only snapshots to perform basic primary site replication.

Chapter 3, "Using Multimaster Replication"
Describes how to create and maintain a multi-master replicated environment using the Oracle advanced replication facility.

Chapter 4, "Using Snapshot Site Replication"
Describes how to create and maintain snapshot sites using the Oracle advanced replication facility. This chapter also describes updatable snapshots.

Chapter 5, "Conflict Resolution"
Describes how to use Oracle-supplied conflict resolution methods to resolve conflicts resulting from dynamic or shared ownership of data in replicated environments.

Chapter 6, "Administering a Replicated Environment"
Describes how to detect and resolve unresolved replication errors as well as how to monitor successful conflict resolution.

Chapter 7, "Advanced Techniques"
Describes advanced replication techniques, including how to do the following: create your own conflict resolution routines, implement fail-over sites, implement token passing, use procedural replication, and manage deletes.

Chapter 8, "Using Deferred Transactions"
Describes how to build transactions for deferred execution at remote locations.

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

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

Appendix A, "New Features"
Briefly describes the new features of this release and refers to sections of this document having more information.

Appendix B, "Migration and Compatibility"
Discusses the compatibility issues between release 8 of the advanced replication option and previous releases.

Conventions Used in This Manual

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

Special Notes

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

Note: Indicates special or auxiliary information.

Attention: Indicates items of particular importance about matters requiring special attention or caution.

Additional Information: Indicates where to get more information.

Text of the Manual

The following sections describe conventions used this manual.

UPPERCASE Characters

Uppercase text is used to call attention to command keywords, object names, parameters, filenames, and so on.

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

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 the book Oracle8 Tuning."

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'); 

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:

Oracle8 Server Documentation Manager
Oracle Corporation
500 Oracle Parkway
Redwood Shores, CA 94065

You can also e-mail comments to:


Copyright © 1997 Oracle Corporation.

All Rights Reserved.