Database Guide › Database Storage and Partitioning › Set Up Partitions and Purging › Create Database Partitions › Add a Specific Partition

Add a Specific Partition

To add a specific partition, you must execute the wgn_add_partition procedure as the schema owner. The prototype is:

wgn_add_partition(date_range IN VARCHAR2);

where:

date_range

Specifies the end date for the new partition.

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

For example, consider a database segmented into partitions 30 days long. If the latest existing partition has an end date of March 7, the command below will add a new partition to hold events with capture dates between March 8 and April 6:

SQL> EXEC wgn_partition_util.wgn_add_partition (date_range=>’06-apr-2011');

Note: Using this command, you can only add a partition newer than the last partition.