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

• str1.net

• str2.net

The str1.net 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.net

The str2.net 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