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 has the following Oracle Streams components configured:

• The following queues: capture_queue and apply_queue.

• A synchronous capture named sync_capture that captures DML changes to the hr.employees and hr.departments tables. The synchronous capture enqueues these changes into the local capture_queue queue.

• A propagation named send_emp_dep that sends changes from the local capture_queue queue to the apply_queue queue at spoke.net.

• An apply process named apply_emp_dep that dequeues changes that originated at spoke.net from the apply_queue queue and applies them to the hr.employees and hr.departments tables.

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

• The following queues: capture_queue and apply_queue.

• A synchronous capture named sync_capture that captures DML changes to the hr.employees and hr.departments tables. The synchronous capture enqueues these changes into the local capture_queue queue.

• A propagation named send_emp_dep that sends changes from the local capture_queue queue to the apply_queue queue at hub.net.

• An apply process named apply_emp_dep that dequeues changes that originated at hub.net from the apply_queue queue and applies them to the hr.employees and hr.departments tables.