This illustration shows an Oracle Streams two-database replication environment that includes the following Oracle databases:
src.net
dest.net
The src.net database contains the redo log for the local database. This redo log records changes to the hr schema. This redo log is sent to the dest.net database by Redo Transport Services.
The dest.net database has the following Oracle Streams components configured:
The streams_queue queue.
A capture process named capture_hns that captures DML changes to the tables in the hr schema from the src.net redo log. The capture process enqueues these changes into the local streams_queue queue.
An apply process named apply that dequeues changes that originated at src.net from the streams_queue queue and applies them to the tables in the hr schema.