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.