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

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.4 [Release 9.2 to 11.2]
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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms