Copyright © 2008, 2013, Oracle and/or its affiliates. All rights reserved.
Legal Notices
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