This illustration shows a Streams replication environment that involves the following Oracle databases:
The following sections describe the configuration at each database.
Configuration at the str1.net Oracle Database
The str1.net Oracle database has the following configuration:
- One Streams queue named streams_queue and owned by the user strmadmin.
- A capture process named capture_simp that captures DML and DDL changes to the hr.jobs table.
- A propagation job named str1_to_str2 that propagates change from the local queue to the strmadmin.streams_queue queue at str2.net.
Configuration at the str2.net Oracle Database
The str2.net Oracle database has the following configuration:
- One Streams queue named streams_queue and owned by the user strmadmin.
- An apply process named apply_simp that applies changes to the hr.jobs table.