Share this page

# Purge data

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 `cdc$_default_purge_job.`

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 `repeat_interval` attribute.

Running 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, refer to 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.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: