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

• str1.example.com

• str2.example.com

The str1.example.com Oracle database has the following configuration:

• One Oracle 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 named str1_to_str2 that propagates change from the local queue to the strmadmin.streams_queue queue at str2.example.com

The str2.example.com Oracle database has the following configuration:

• One Oracle 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