oracle list 分区详解,全面学习分区表及分区索引

JSSWEB> create table t_partition_rl (id number,name varchar2(50))

2  partition by range(id) subpartition by list(name)

3  subpartition template (

4   subpartition l1 values (¨aa¨) tablespace tbspart01,

5   subpartition l2 values (¨bb¨) tablespace tbspart02,

6   subpartition l3 values (¨cc¨) tablespace tbspart03,

7   subpartition l4 values (¨dd¨) 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_RL¨;

PARTITION_NAME  SUBPARTITION_NAME              TABLESPACE_NAME

--------------- ------------------------------ --------------------

T_R_P1          T_R_P1_L4                      TBSPART01

T_R_P1          T_R_P1_L3                      TBSPART01

T_R_P1          T_R_P1_L2                      TBSPART01

T_R_P1          T_R_P1_L1                      TBSPART01

T_R_P2          T_R_P2_L4                      TBSPART02

T_R_P2          T_R_P2_L3                      TBSPART02

T_R_P2          T_R_P2_L2                      TBSPART02

T_R_P2          T_R_P2_L1                      TBSPART02

T_R_P3          T_R_P3_L4                      TBSPART03

T_R_P3          T_R_P3_L3                      TBSPART03

T_R_P3          T_R_P3_L2                      TBSPART03

T_R_P3          T_R_P3_L1                      TBSPART03

T_R_PD          T_R_PD_L4                      TBSPART04

T_R_PD          T_R_PD_L3                      TBSPART04

T_R_PD          T_R_PD_L2                      TBSPART04

T_R_PD          T_R_PD_L1                      TBSPART04

已选择16行。