This illustration shows an Oracle Streams replication environment that involves the following Oracle databases:
mult1.example.com
mult2.example.com
mult3.example.com
The mult1.example.com Oracle database has the following configuration:
The following three ANYDATA queues owned by the strmadmin user: captured_mult1, from_mult2, and from_mult3.
A capture process named capture_hrmult that captures DML and DDL changes to the tables in the hrmult schema: countries, departments, employees, job_history, jobs, locations, and regions. The capture process enqueues these changes into the captured_mult1 queue.
A propagation named mult1_to_mult2 that propagates changes from the local captured_mult1 queue to the from_mult1 queue at mult2.example.com.
A propagation named mult1_to_mult3 that propagates changes from the local captured_mult1 queue to the from_mult1 queue at mult3.example.com.
An apply process named apply_from_mult2 that dequeues changes that originated at mult2.example.com from the from_mult2 queue and applies them to the tables in the hrmult schema.
An apply process named apply_from_mult3 that dequeues changes that originated at mult3.example.com from the from_mult3 queue and applies them to the tables in the hrmult schema.
The mult2.example.com Oracle database has the following configuration:
The following three ANYDATA queues owned by the strmadmin user: captured_mult2, from_mult1, and from_mult3.
A capture process named capture_hrmult that captures DML and DDL changes to the tables in the hrmult schema: countries, departments, employees, job_history, jobs, locations, and regions. The capture process enqueues these changes into the captured_mult2 queue.
A propagation named mult2_to_mult1 that propagates changes from the local captured_mult2 queue to the from_mult2 queue at mult1.example.com.
A propagation named mult2_to_mult3 that propagates changes from the local captured_mult2 queue to the from_mult2 queue at mult3.example.com.
An apply process named apply_from_mult1 that dequeues changes that originated at mult1.example.com from the from_mult1 queue and applies them to the tables in the hrmult schema.
An apply process named apply_from_mult3 that dequeues changes that originated at mult3.example.com from the from_mult3 queue and applies them to the tables in the hrmult schema.
The mult3.example.com Oracle database has the following configuration:
The following three ANYDATA queues owned by the strmadmin user: captured_mult3, from_mult1, and from_mult2.
A capture process named capture_hrmult that captures DML and DDL changes to the tables in the hrmult schema: countries, departments, employees, job_history, jobs, locations, and regions. The capture process enqueues these changes into the captured_mult3 queue.
A propagation named mult3_to_mult1 that propagates changes from the local captured_mult3 queue to the from_mult3 queue at mult1.example.com.
A propagation named mult3_to_mult2 that propagates changes from the local captured_mult3 queue to the from_mult3 queue at mult2.example.com.
An apply process named apply_from_mult1 that dequeues changes that originated at mult1.example.com from the from_mult1 queue and applies them to the tables in the hrmult schema.
An apply process named apply_from_mult2 that dequeues changes that originated at mult2.example.com from the from_mult2 queue and applies them to the tables in the hrmult schema.