Illustration strep035.htm shows a Streams replication environment that involves the following Oracle databases:
str1.net
str2.net
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 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 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