Last updated on MAY 15, 2017
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 9.2 to 11.1]
Information in this document applies to any platform.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms