Database Guide › Database Storage and Partitioning › Set Up Partitions and Purging › Set Up Partition-Based Purging › Purge a Specific Partition

Purge a Specific Partition

You can also use the wgn_roll_partitions procedure to purge a specific partition. To do this, you set the new_partiton_date_range parameter to NULL. For example, this command purges the partition with an end date of 31 January 2007:

begin 
wgn_partition_util.wgn_roll_partitions
(null,'31-jan-2007');
end;