What are the different ways to configure streams for data replication?

posted Apr 26, 2012, 7:27 AM by Sachchida Ojha   [ updated Apr 26, 2012, 7:29 AM ]
In general, there are 3 most common ways to configure streams replication.

1. Using OEM Stream Replication Setup  Wizard

2. Using Oracle supplied procedures in the DBMS_STREAMS_ADM package (MAINTAIN_* procedures).

The DBMS_STREAMS_ADM package, one of a set of Oracle Streams packages, provides subprograms for configuring Oracle Streams environments. This package also includes subprograms for adding and removing simple rules for capture, propagation, apply, and dequeue at the table, schema, and database level.

3. Using Custom Scripts