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.

The hub.net database has the following Oracle Streams components configured:

• A queue with a system-generated name.

• A capture process with a system-generated name that captures DML changes to the tables in the hr schema from the local redo log. The capture process enqueues these changes into the local queue.

• A propagation with a system-generated name that sends changes from the local source queue to the destination queue at spoke.net.

The spoke.net database has the following Oracle Streams components configured:

• A queue with a system-generated name.

• An apply process with a system-generated name that dequeues changes that originated at hub.net from the local queue and applies them to the tables in the hr schema.