Description of the illustration strms036.eps

This illustration shows the following Oracle Streams configuration at the cpap.example.com database:

• One queue named streams_queue and owned by the user strmadmin.

• One capture process named capture_emp captures DML changes to the hr.employees table and enqueues these changes into the streams_queue.

• An apply process named apply_emp that sends row LCRs involving the hr.employees table to a procedure DML handler, which is the emp_dml_handler PL/SQL procedure. The apply process reenqueues all messages back into the streams_queue for processing by an application.

• The emp_dml_handler converts DELETE operations on the hr.employees table into INSERT operations on the hr.emp_del table and inserts these changes into the table.