Database Guide › Database Storage and Partitioning › Set Up Partitions and Purging › Customize Your Partitioning Scheme › MAXVALUE Partition Name

MAXVALUE Partition Name

The MAXVALUE partition contains any ‘anomalous’ records whose time-stamp date does not match an existing partition. For example, if the latest partition has an end date of 31 January 2007, the MAXVALUE partition accepts all events with a timestamp of 1 February 2007 or later. If a new partition is created subsequently with a date range that matches these anomalous records, they are automatically migrated out of the MAXVALUE partition and into the new partition.

The MAXVALUE partition name uses this pattern: :

<table name>_DEF

For example:

WGN3EVENT_DEF

If required, you can customize this partition name. The function prototype is shown below:

FUNCTION wgn_get_maxvalue_name
(table_name IN VARCHAR2) 
RETURN VARCHAR2;