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

• sync1.net

• sync2.net

The sync1.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 sync2.net.

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

The sync2.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 sync1.net.

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