Change delivery is the process of applying the logical change records (LCR) generated from transactions that occurred on the source database. The data delivery is the responsibility of the Replicat process that mines the remote trail files, converts the LCRs to DML and DDL statements, and applies them to the target database. This process can often cause a bottleneck, depending on the volume of data being replicated. Oracle recommends enabling Integrated Capture or Coordinated Delivery against the target database to leverage parallel processing and enhance the performance of Replicat.
For this example, we will create one Replicat named
ROLAP01 to apply DML to the
DEPT tables in the
PDB2: TGT schema. For a nonCDB ...