ALTER TABLE...SET SUBPARTITION TEMPLATE v13

Use the ALTER TABLE… SET SUBPARTITION TEMPLATE command to update the subpartition template for a table. The syntax is:

ALTER TABLE <table_name> SET SUBPARTITION TEMPLATE <num>;

To reset the subpartitions number to default using the subpartition template, the syntax is:

ALTER TABLE <table_name> SET SUBPARTITION TEMPLATE ();

Parameters

table_name

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

num

The number of subpartitions to be added for a partition.

Description

The ALTER TABLE… SET SUBPARTITION TEMPLATE command can be used to update the subpartition template in the table. If you are specifying a subpartition descriptor for a partition then a subpartition descriptor is used instead of a subpartition template. The subpartition template can be used whenever a subpartition descriptor is not specified for a partition. If either subpartition descriptor or subpartition template is not specified, then by default a single subpartition is created.

The ALTER TABLE… SET SUBPARTITION TEMPLATE () command can be used to reset the subpartitions number to default 1.