Oracle 添加分区 hash,全面学习分区表及分区索引

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

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

3  subpartitions 4 store in (tbspart01, tbspart02, tbspart03,tbspart04)(

4  partition t_r_p1 values less than (10) tablespace tbspart01,

5  partition t_r_p2 values less than (20) tablespace tbspart02,

6  partition t_r_p3 values less than (30) tablespace tbspart03,

7  partition t_r_pd values less than (maxvalue) tablespace tbspart04);

表已创建。

JSSWEB> select partitioning_type,subpartitioning_type,partition_count,def_subpartition_count

2  From user_part_tables where table_name=¨T_PARTITION_RH¨;

PARTITI SUBPART PARTITION_COUNT DEF_SUBPARTITION_COUNT

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

RANGE   HASH                  4                      4

JSSWEB> select partition_name,subpartition_count,high_value

2  from user_tab_partitions where table_name=¨T_PARTITION_RH¨;

PARTITION_NAME  SUBPARTITION_COUNT HIGH_VALUE

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

T_R_P2                           4 20

T_R_P3                           4 30

T_R_PD                           4 MAXVALUE

T_R_P1                           4 10

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_P2          SYS_SUBP140                    TBSPART02

T_R_P2          SYS_SUBP139                    TBSPART02

T_R_P2          SYS_SUBP138                    TBSPART02

T_R_P2          SYS_SUBP137                    TBSPART02

T_R_P3          SYS_SUBP144                    TBSPART03

T_R_P3          SYS_SUBP143                    TBSPART03

T_R_P3          SYS_SUBP142                    TBSPART03

T_R_P3          SYS_SUBP141                    TBSPART03

T_R_PD          SYS_SUBP148                    TBSPART04

T_R_PD          SYS_SUBP147                    TBSPART04

T_R_PD          SYS_SUBP146                    TBSPART04

T_R_PD          SYS_SUBP145                    TBSPART04

T_R_P1          SYS_SUBP133                    TBSPART01

T_R_P1          SYS_SUBP136                    TBSPART01

T_R_P1          SYS_SUBP135                    TBSPART01

T_R_P1          SYS_SUBP134                    TBSPART01

已选择16行。