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.