Oracle Database Advanced Replication describes the features and functionality of Advanced Replication. Specifically, Oracle Database Advanced Replication contains conceptual information about Advanced Replication, as well as information about planning your replication environment and troubleshooting replication problems.

This Preface contains these topics:


Oracle Database Advanced Replication is intended for database administrators and application developers who develop and maintain replication environments. These administrators and application developers perform one or more of the following tasks:

  • Plan for a replication environment

  • Configure the following types of replication environments:

    • Read-only materialized view

    • Updatable materialized view

    • Single master replication

    • Multimaster replication

  • Use deployment templates to create a materialized view environment

  • Configure conflict resolution

  • Administer a replication environment

  • Perform troubleshooting activities when necessary

  • Manage job queues

  • Manage deferred transactions

  • Use the Advanced Replication interface in Oracle Enterprise Manager to create, monitor, and manage replication environments

To use this document, you need to be familiar with relational database concepts, distributed database administration, PL/SQL (if using procedural replication), and the operating system under which you run an Advanced Replication environment.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at

Access to Oracle Support

Oracle customers have access to electronic support through My Oracle Support. For information, visit or visit if you are hearing impaired.

Related Documents

For more information, see these Oracle resources:

Many of the examples in this book use the sample schemas of the sample database, which is installed by default when you install Oracle Database. Refer to Oracle Database Sample Schemas for information about how these schemas were created and how you can use them.


The following text conventions are used in this document:

Convention Meaning
boldface Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary.
italic Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values.
monospace Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.