create table tb_p_test
(
  RECDATE      NUMBER(8) not null,
  USERNUMBER   VARCHAR2(32) not null,
  PROVCODE     NUMBER(5) default 0 not null,
  count        number
  
)
partition by range (RECDATE) subpartition by list(PROVCODE)
subpartition template ( 
 subpartition p_00  values (0)   , 
 subpartition p_01  values (1)   ,
 subpartition p_02  values (2)   , 
 Subpartition p_null Values(Null)
 )
(
  partition p_20110801 values less than (20110802),
  partition p_20110802 values less than (20110803)
);

Alter Table TB_HXL_USER Set Subpartition Template
(
subpartition p_00  values (0)   , 
 subpartition p_01  values (1)   ,
 subpartition p_02  values (2)   , 
 Subpartition p_null Values(Null),
 Subpartition p_default Values(default)
)