ALTER TABLE...SET INTERVAL v16

Use the ALTER TABLE… SET INTERVAL command to convert an existing range-partitioned table to an interval range-partitioned table. The database creates a partition of a specified range or interval for the partitioned table when you set INTERVAL. The syntax is:

ALTER TABLE <table_name> SET INTERVAL (<constant> | <expression>);

To disable an interval range partitioned table and convert it to a range-partitioned table, the syntax is:

ALTER TABLE <table_name> SET INTERVAL ();

Parameters

table_name

The name (optionally schema-qualified) of the range-partitioned table.

constant | expression

Specifies a NUMERIC, DATE, or TIME value.

Description

You can use the ALTER TABLE… SET INTERVAL command to convert the range-partitioned table to use interval range partitioning. The command creates a new partition of a specified interval. You can then insert data into the new partition.

You can use the SET INTERVAL () command to disable interval range partitioning. The database converts an interval range-partitioned table to range partitioned and sets the boundaries of the interval range partitions to the boundaries for the range partitions.

example_setting_an_interval_range_partition