You are here: Decision Strategy Manager > Interaction History > Applying sample scripts for archiving and purging > Deleting the records from the FACT table in Oracle databases

Deleting the records from the FACT table

Perform this procedure to delete records from the FACT table.

Connect to the source database.
Execute the following script:

DELETE FROM PR_DATA_IH_FACT WHERE PXOUTCOMETIME < TO_DATE(<DATE_STRING>, <DATE_FORMAT_STRING>);

Example:

DELETE FROM PR_DATA_IH_FACT WHERE PXOUTCOMETIME < TO_DATE('2015-01-07', 'YYYY-MM-DD')