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