Configuring change delivery

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 EMP and DEPT tables in the PDB2: TGT schema. For a nonCDB database, the schema will be TGT in our OLAP target database.

For classic mode, the first step in order to configure Change Data Delivery (CDD) is the creation of a Checkpoint table. This is optional; Oracle highly recommends it over the default...