Purging Data from Financial Technical Tables
Introduction
The purging of financial technical tables is implemented in the database as a PL/SQL package.
Package OHI_FIN_PURGE_PKG
ohi_fin_purge_pkg.purge_all
( p_keep_days in integer
, p_commit_size
);
Parameter |
Description |
Mandatory |
Default Value |
p_keep_days |
Number of days of history that are retained. Records created within the last p_keep_days are not purged but other records are purged. This means records which are between created_Date < = (sysdate - p_keep_days) are purged. |
Yes |
Not less than 30. |
p_commit_size |
Number of records that is purged in a single transaction |
No |
1000 Higher commit sizes make the process faster, but needs more undo space in the database. |