Add a Series of Partitions

To add a series of partitions, you must execute the wgn_partition_tables procedure as the schema owner. The prototype is shown below:

wgn_partition_tables
  (date_range IN VARCHAR2,
  num_partitions IN NUMBER,
  num_days_per_partition IN NUMBER);

Where:

date_range

Is the end date of the earliest partition.

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

num_partitions

Specifies the number of partitions you want to create.

num_days_per_partition

Is the number of days in each partition.

For example, the command below creates 12 partitions, starting on 31 January 2011, and each 30 days long:

SQL> EXEC wgn_partition_util.wgn_partition_tables(date_range=>'31-jan-2011',
  num_partitions=>12, num_days_per_partition=>30);