Oracle Replication Introduction

What is Replication ?
Replication is the process of copying and maintaining database objects, such as tables, in multiple databases that make up a distributed database system. However, Streams is the preferred way to set up Replication in Oracle databases. Following are the replication types

Read-Only Materialized Replication

Read-Only Materialized Views Based Replication Configuration

“A master table is copied to one or more databases. Changes in the master table are reflected in the snapshot tables whenever the snapshot refreshes. The snapshot site determines the frequency of the refreshes; data is pulled”

Read-only snapshot sites can be used to provide local access to remote master tables. Having a local snapshot of the data improves query response time. Updates can only be issued against the master table.

Multi-Master Replication

Multi-Master(Advance Replication) Step by Step Configuration


Advanced Replication is the process of copying and maintaining database objects, such as tables, in multiple databases that make up a distributed database system. However, Streams is the preferred way to set up Replication in Oracle databases. Following are the replication types