This illustration shows an Oracle Streams two-database replication environment that includes the following Oracle databases:
src.example.com 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.example.com database by Redo Transport Services.
dest.example.com database has the following Oracle Streams components configured:
A capture process named
capture_hns that captures DML changes to the tables in the
hr schema from the
src.example.com redo log. The capture process enqueues these changes into the local queue.
An apply process named
apply that dequeues changes that originated at
src.example.com from the queue and applies them to the tables in the