In PPM schema, the change data is captured and stored in <
ppm_table>_cdc tables. PPM uses the DBMS_SCHEDULER package to create a purge job named
This purge job calls the
PPM_CDC.PURGE_CDC procedure to remove data that has been processed by incremental ETL. By default,
cdc$_default_purge_job runs every 24 hours. You can reschedule the purge job using
DBMS_SCHEDULER.SET_ATTRIBUTE and setting the
cdc$_default_purge_job regularly ensures that the tables do not grow without limit. If you have a large volume of data and need to schedule frequent incremental ETL jobs, you can schedule the
cdc$_default_purge_job to run more frequently than the default of every 24 hours.
For information about the DBMS_SCHEDULER package, see the Oracle documentation.
Note: Do not manually delete data in <
ppm_table>_cdc tables. Always call the
PURGE_CDC procedure to remove them, otherwise, the data in PPM schema and reporting schema are not synchronized.