This illustration shows an Oracle Streams hub-and-spoke replication environment that includes the following Oracle databases:

• hub.net

• spoke.net

The hub.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 spoke.net database by Redo Transport Services.

The spoke.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 hub.net redo log. The capture process enqueues these changes into the local streams_queue queue.

• An apply process named apply_spoke that dequeues changes that originated at hub.net from the streams_queue queue and applies them to the tables in the hr schema.