day11_分区表------子分区的母模板(11g)
create table haha
(
PROVINCE_CODE VARCHAR2(3),
CITY_CODE VARCHAR2(4),
NET_TYPE VARCHAR2(10),
STATION_NAME VARCHAR2(100),
STATION_ID VARCHAR2(64),
SUMBYTES NUMBER(20),
DURATION NUMBER(20),
BASE_DATE varchar2(10),
SEQNO_COU NUMBER,
SEQNO_PRO NUMBER,
SEQNO_CITY NUMBER
)
partition by list (BASE_DATE)
subpartition by list (PROVINCE_CODE)
SUBPARTITION TEMPLATE
(
subpartition BASEDATA010 values ('010') tablespace NODEB,
subpartition BASEDATA011 values ('011') tablespace NODEB,
subpartition BASEDATA013 values ('013') tablespace NODEB,
subpartition BASEDATA017 values ('017') tablespace NODEB,
subpartition BASEDATA018 values ('018') tablespace NODEB,
subpartition BASEDATA019 values ('019') tablespace NODEB,
subpartition BASEDATA030 values ('030') tablespace NODEB,
subpartition BASEDATA031 values ('031') tablespace NODEB,
subpartition BASEDATA034 values ('034') tablespace NODEB,
subpartition BASEDATA036 values ('036') tablespace NODEB,
subpartition BASEDATA038 values ('038') tablespace NODEB,
subpartition BASEDATA050 values ('050') tablespace NODEB,
subpartition BASEDATA051 values ('051') tablespace NODEB,
subpartition BASEDATA059 values ('059') tablespace NODEB,
subpartition BASEDATA070 values ('070') tablespace NODEB,
subpartition BASEDATA071 values ('071') tablespace NODEB,
subpartition BASEDATA074 values ('074') tablespace NODEB,
subpartition BASEDATA075 values ('075') tablespace NODEB,
subpartition BASEDATA076 values ('076') tablespace NODEB,
subpartition BASEDATA079 values ('079') tablespace NODEB,
subpartition BASEDATA081 values ('081') tablespace NODEB,
subpartition BASEDATA083 values ('083') tablespace NODEB,
subpartition BASEDATA084 values ('084') tablespace NODEB,
subpartition BASEDATA085 values ('085') tablespace NODEB,
subpartition BASEDATA086 values ('086') tablespace NODEB,
subpartition BASEDATA087 values ('087') tablespace NODEB,
subpartition BASEDATA088 values ('088') tablespace NODEB,
subpartition BASEDATA089 values ('089') tablespace NODEB,
subpartition BASEDATA090 values ('090') tablespace NODEB,
subpartition BASEDATA091 values ('091') tablespace NODEB,
subpartition BASEDATA097 values ('097') tablespace NODEB,
subpartition BASEDATA00 values (default) tablespace NODEB
)
(
partition p20140301 values ('2014-03-01') ,
partition p20140302 values ('2014-03-02') ,
partition p20140303 values ('2014-03-03') ,
partition p20140304 values ('2014-03-04') ,
partition p20140305 values ('2014-03-05') ,
partition p20140306 values ('2014-03-06') ,
partition p20140307 values ('2014-03-07') ,
partition p20140308 values ('2014-03-08') ,
partition p20140309 values ('2014-03-09') ,
partition p20140310 values ('2014-03-10') ,
partition p20140311 values ('2014-03-11') ,
partition p20140312 values ('2014-03-12') ,
partition p20140313 values ('2014-03-13') ,
partition p20140314 values ('2014-03-14') ,
partition p20140315 values ('2014-03-15') ,
partition p20140316 values ('2014-03-16') ,
partition p20140317 values ('2014-03-17') ,
partition p20140318 values ('2014-03-18') ,
partition p20140319 values ('2014-03-19') ,
partition p20140320 values ('2014-03-20') ,
partition p20140321 values ('2014-03-21') ,
partition p20140322 values ('2014-03-22') ,
partition p20140323 values ('2014-03-23') ,
partition p20140324 values ('2014-03-24') ,
partition p20140325 values ('2014-03-25') ,
partition p20140326 values ('2014-03-26') ,
partition p20140327 values ('2014-03-27') ,
partition p20140328 values ('2014-03-28') ,
partition p20140329 values ('2014-03-29') ,
partition p20140330 values ('2014-03-30') ,
partition p20140331 values ('2014-03-31')
);
