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.