深入学习分区表及分区索引(5)--创建range-hash组合分区(续)

①　分区模板的应用

oracle还提供了一种称为分区模板的功能，在指定子分区信赖列之后，制订子分区的存储模板，各个分区即会按照子分区模式创建子分区，例如：

JSSWEB> create table t_partition_rh (id number,name varchar2(50))  2  partition by range(id) subpartition by hash(name)  3  subpartition template (  4   subpartition h1 tablespace tbspart01,  5   subpartition h2 tablespace tbspart02,  6   subpartition h3 tablespace tbspart03,  7   subpartition h4 tablespace tbspart04)(  8  partition t_r_p1 values less than (10) tablespace tbspart01,  9  partition t_r_p2 values less than (20) tablespace tbspart02, 10  partition t_r_p3 values less than (30) tablespace tbspart03, 11  partition t_r_pd values less than (maxvalue) tablespace tbspart04);表已创建。JSSWEB> select partition_name,subpartition_name,tablespace_name  2  from user_tab_subpartitions where table_name='T_PARTITION_RH';PARTITION_NAME  SUBPARTITION_NAME              TABLESPACE_NAME--------------- ------------------------------ --------------------T_R_P1          T_R_P1_H4                      TBSPART01T_R_P1          T_R_P1_H3                      TBSPART01T_R_P1          T_R_P1_H2                      TBSPART01T_R_P1          T_R_P1_H1                      TBSPART01T_R_P2          T_R_P2_H4                      TBSPART02T_R_P2          T_R_P2_H3                      TBSPART02T_R_P2          T_R_P2_H2                      TBSPART02T_R_P2          T_R_P2_H1                      TBSPART02T_R_P3          T_R_P3_H4                      TBSPART03T_R_P3          T_R_P3_H3                      TBSPART03T_R_P3          T_R_P3_H2                      TBSPART03T_R_P3          T_R_P3_H1                      TBSPART03T_R_PD          T_R_PD_H4                      TBSPART04T_R_PD          T_R_PD_H3                      TBSPART04T_R_PD          T_R_PD_H2                      TBSPART04T_R_PD          T_R_PD_H1                      TBSPART04已选择16行。=======================================