create table tb_hxl_user_split
(
  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 list(provcode)
subpartition template ( 
 subpartition p_1 values (1) ,
 subpartition p_2 values (2) , 
 subpartition p_3 values (3) ,
 subpartition p_4 values (4) , 
 subpartition p_5 values (5) ,
 subpartition p_default values (default) ,
 )
(
  partition hxl_user_20111001 values less than 
(to_date(' 2011-10-02 00:00:00', 'syyyy-mm-dd hh24:mi:ss', 'nls_calendar=gregorian'))
); 

insert into tb_hxl_user_split(statedate,provcode,usernumber) values(date'2011-01-01',1,'12301');
insert into tb_hxl_user_split(statedate,provcode,usernumber) values(date'2011-01-01',2,'12302');
insert into tb_hxl_user_split(statedate,provcode,usernumber) values(date'2011-01-01',3,'12303');
insert into tb_hxl_user_split(statedate,provcode,usernumber) values(date'2011-01-01',4,'12304');
insert into tb_hxl_user_split(statedate,provcode,usernumber) values(date'2011-01-01',5,'12305');
insert into tb_hxl_user_split(statedate,provcode,usernumber) values(date'2011-01-01',6,'12306');

SQL> alter table tb_hxl_user_split split subpartition HXL_USER_20111001_P_DEFAULT
  2  values (6) into (subpartition HXL_USER_20111001_P_6, subpartition HXL_USER_20111001_P_DEFAULT);

Table altered.

SQL> alter table tb_hxl_user_split set subpartition template ( 
  2   subpartition p_1 values (1) ,
  3   subpartition p_2 values (2) , 
  4   subpartition p_3 values (3) ,
  5   subpartition p_4 values (4) , 
  6   subpartition p_5 values (5) ,
  7   subpartition p_6 values (6) ,
  8  subpartition p_default values (default)
  9  );

Table altered.