使用子分区模板创建range-hash分区

1.创建range-hash分区

-- Create table

create table TB_HXL_USER_RH
(
  STATEDATE DATE not null,
  PROVCODE NUMBER not null,
  USERNUMBER VARCHAR2(13) not null,
  REM1 VARCHAR2(1024),
  CREATE_DATE DATE,
  CREATE_BY NUMBER,
  LAST_UPDATE_DATE DATE,
  LAST_UPDATE_BY NUMBER
)
partition by range (statedate) subpartition by hash(USERNUMBER)
subpartition template (
 subpartition p_sub_h1 tablespace USERS,
 subpartition p_sub_h2 tablespace USERS,
 subpartition p_sub_h3 tablespace USERS,
 subpartition p_sub_h4 tablespace USERS,
 subpartition p_sub_h5 tablespace USERS,
 subpartition p_sub_h6 tablespace USERS,
 subpartition p_sub_h7 tablespace USERS,
 subpartition p_sub_h8 tablespace USERS,
 subpartition p_sub_h9 tablespace USERS,
 subpartition p_sub_h10 tablespace USERS
 )
(
  partition HXL_USER_20110516 values less than (TO_DATE(' 2011-05-17 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    tablespace USERS
    pctfree 10
    initrans 1
    maxtrans 255
    storage
    (
      initial 64K
      next 1M
      minextents 1
      maxextents unlimited
    )
);