This illustration shows an Oracle Streams two-database replication environment that includes the following Oracle databases:

• src.example.com

• dest.example.com

The 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.

The dest.example.com 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.example.com 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.example.com from the streams_queue queue and applies them to the tables in the hr schema.