This illustration shows the following process for row migration during capture:
A user makes the following update to a table:
UPDATE hr.employees SET department_id=50 WHERE employee_id=167;
The source database records the change in the redo log.
A capture process captures the change and transforms the
INSERTbecause the change satisfies a subset rule.
The capture process enqueues the transformed LCR at the source database.
A propagation propagates the LCR to a queue at the destination database.
An apply process dequeues the change and applies it as an
hr.employeessubset table. This subset table contains rows only for employees with a