This illustration shows the following Oracle Streams configuration at the
One queue named
streams_queueand owned by the user
One capture process named
capture_empcaptures DML changes to the
hr.employeestable and enqueues these changes into the
An apply process named
apply_empthat sends row LCRs involving the
hr.employeestable to a procedure DML handler, which is the
emp_dml_handlerPL/SQL procedure. The apply process reenqueues all messages back into the
streams_queuefor processing by an application.
DELETEoperations on the
INSERToperations on the
hr.emp_deltable and inserts these changes into the table.