My Oracle Support Banner

How To Add an active Database to An Existing Bi-directional Streams Replication Environment (Doc ID 779407.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.1.0.6 [Release 9.2 to 11.1]
Information in this document applies to any platform.

Goal

This sample demonstrates adding a site ( a database node) to an existing two-way Streams replication environment while the site is active. A site is an active site if the tables in its schema to be replicated, are being modified by DML (Inserts/Updates/Deletes) . DDL can also be performed on the tables except while the export of the tables is performed for instantiation. Using the procedure detailed below, the existing processes in the streams environment continue to perform their assigned tasks and users continue their activity on the site while the site is added into the replication configuration. This example illustrates two-way capture, propagation and application of the schema DML and DDL change events between three different databases. The sample  adds a third database to an existing bi-directional streams environment.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.