Untitled

This illustration shows a Streams replication environment that involves the following databases:

The following sections describe the configuration at each database.

The mult1.net Oracle database has the following configuration:

One Streams queue named streams_queue and owned by the user strmadmin.
A capture process named capture_hr that captures DML and DDL changes to the tables in the hr schema: countries, departments, employees, job_history, jobs, locations, and regions.
A propagation job named mult1_to_mult2 that propagates changes from the local queue to the strmadmin.streams_queue queue at mult2.net.
A propagation job named mult1_to_mult3 that propagates changes from the local queue to the strmadmin.streams_queue queue at mult3.net.
An apply process named apply_from_mult2 that applies changes to the tables in the hr schema that originated at mult2.net.
An apply process named apply_from_mult3 that applies changes to the tables in the hr schema that originated at mult3.net.

The mult2.net Oracle database has the following configuration:

One Streams queue named streams_queue and owned by the user strmadmin.
A capture process named capture_hr that captures DML and DDL changes to the tables in the hr schema: countries, departments, employees, job_history, jobs, locations, and regions.
A propagation job named mult2_to_mult1 that propagates changes from the local queue to the strmadmin.streams_queue queue at mult1.net.
A propagation job named mult2_to_mult3 that propagates changes from the local queue to the strmadmin.streams_queue queue at mult3.net.
An apply process named apply_from_mult1 that applies changes to the tables in the hr schema that originated at mult1.net.
An apply process named apply_from_mult3 that applies changes to the tables in the hr schema that originated at mult3.net.

The mult3.net Oracle database has the following configuration:

One Streams queue named streams_queue and owned by the user strmadmin.
A capture process named capture_hr that captures DML and DDL changes to the tables in the hr schema: countries, departments, employees, job_history, jobs, locations, and regions.
A propagation job named mult3_to_mult1 that propagates changes from the local queue to the strmadmin.streams_queue queue at mult1.net.
A propagation job named mult3_to_mult2 that propagates changes from the local queue to the strmadmin.streams_queue queue at mult2.net.
An apply process named apply_from_mult1 that applies changes to the tables in the hr schema that originated at mult1.net.
An apply process named apply_from_mult2 that applies changes to the tables in the hr schema that originated at mult2.net.