Subpartition template usage

Subpartition template I have never known about the subpartition template. I tried it today. It is quite fun and useful. You do not need to fill in subpartitions when adding partitions during maintenance. The following is an example:

Create table t_test_subtemplate (rec_type varchar2 (10), capture_time varchar2 (30), uuid varchar2 (30) partition by range (capture_time) subpartition by list (uuid) subpartition template (subpartition sp00 values ('1'), subpartition sp01 values ('2') (partition part_201101 values less than (20130130 ), partition part_201102 values less than (20130230 ));

 

You can create a partition table normally. However, note that the subpartition contains the subpartition template, which is the subpartition template. Then you only need to add the primary partition to create the subpartition automatically.

Alter table t_test_subtemplate add partition part_201104 values less than (20130330 );

 

The following table view shows the sub-partitions.