Database Guide › Database Storage and Partitioning › Set Up Partitions and Purging › Set Up Partition-Based Purging › Set up Rolling Partitions

Set up Rolling Partitions

In a typical RANGE partitioning model, the purge operation periodically purges the specified partition and adds a new partition.

To define your rolling partitions, you must execute the wgn_roll_partitions procedure in the wgn_partition_util package. The prototype is shown below:

wgn_roll_partitions
(new_partition_date_range IN VARCHAR2,
date_range_to_purge IN VARCHAR2,
perm_data_date_range IN VARCHAR2 := null,
pdebug in boolean := false);

where:

new_partition_date_range

Specifies the end date for the new partition.

This parameter adds the new partition into the existing tablespace. In the Wgn3PurgeHistory table, this date is listed in the P1 column. You can also set this parameter to NULL to purge a specific partition without adding a new one—see the next section.

By default, the date format must be dd-mmm-yyyy (for example, 08-mar-2011).

date_range_to_purge

Specifies the end date for the partition that you want to purge. Date formats are as above.

This parameter purges all non‑permanent data from the partition specified by the date_range_to_purge parameter. In the Wgn3PurgeHistory table, this date is listed in the P2 column.

perm_data_date_range

Is an optional parameter that specifies the end date for the historic partition. Date formats are as above.

If this parameter is not specified, permanent records stay in their original partition. In the Wgn3PurgeHistory table, this date is listed in the P3 column.

pdebug

Is an optional prameter to specify whether a debug trace is produced. It defaults to false.

More information:

Wgn3PurgeHistory

Historic Partitions

Example Purge Sequence