Database Guide › Database Storage and Partitioning › Set Up Partitions and Purging › Customize Your Partitioning Scheme › Customizable Retention Conditions

Customizable Retention Conditions

By default, each purge operation purges the specified partition but retains any events marked as 'Do Not Delete' in the Wgn3Event table. However, you can customize the purge to retain other categories of events, such as all events whose status is not 'Closed'.

To define a retention condition, customize the following function:

FUNCTION wgn_get_retention_condition
(table_name IN VARCHAR2,
date_range IN VARCHAR2)
RETURN VARCHAR2;

Where:

table_name

Specifies the database table being checked for events that must be retained.

date_range

Specifies the end date for the partition being purged.