My Oracle Support Banner

How To Add An Active Table To Existing Bi-directional Streams Replication Environment (Doc ID 753233.1)

Last updated on AUGUST 31, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.4 [Release 9.2 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Goal

This sample demonstrates adding a table into an existing bi-directional Streams replication environment while the table is active. A table is an active table if it is being modified by DML (Inserts/Updates/Deletes). DDL can also be performed on the table except while the export of the table 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 table while the table is added into the replication configuration. This example illustrates bi-directional capture, propagation and application of the table DML and DDL change events between two different databases.

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.