Oracle 复合分区

create table WZW_SALES
(
  ACCT_NO      NUMBER(5),
  PERSON       VARCHAR2(30),
  SALES_AMOUNT NUMBER(8),
  WEEK_NO      NUMBER(2)
)
partition by range (WEEK_NO)
subpartition by list (ACCT_NO)
(
  partition PART9 values less than (9)
    tablespace DW_CDR_DATA
    pctfree 10
    pctused 40
    initrans 1
    maxtrans 255
  (
    subpartition SUB1_PART9 values (1001) tablespace DW_CDR_DATA,
    subpartition SUB2_PART9 values (1002) tablespace DW_CDR_DATA
  ),
  partition PART11 values less than (11)
    tablespace DW_CDR_DATA
    pctfree 10
    pctused 40
    initrans 1
    maxtrans 255
  (
    subpartition SUB1_PART11 values (2001) tablespace DW_CDR_DATA,
    subpartition SUB2_PART11 values (2002) tablespace DW_CDR_DATA
  )
);

select * from wzw_sales partition (part9);
select * from wzw_sales subpartition (sub1_part9);

insert into wzw_sales values (1001,'person1',1245,8);
insert into wzw_sales values (1002,'person2',2845,7);
insert into wzw_sales values (2001,'person3',3645,9);
insert into wzw_sales values (2002,'person4',4945,10);

grant create any table to dw;