1、复合分区可以是:范围-列表,范围-HASH11g增加:RANGE-RANGE、LIST-RANGE、LIST-HASH和LIST-LIST1.子分区创建(范围-列表)CREATE TABLE mylong(MYDATE DATE,ATYPE NUMBER,ABC NUMBER)PARTITION BY RANGE(MYDATE)SUBPARTITION BY list(ATYPE)SUBPARTITION TEMPLATE(SUBPARTITION "A" VALUES(1) TABLESPACE users,SUBPARTITION "B"
2、 VALUES(3) TABLESPACE users)(PARTITION MY_ VALUES less than (TO_DATE('','yyyymmdd')),PARTITION MY_ VALUES less than (TO_DATE('','yyyymmdd')),PARTITION MY_ VALUES less than (TO_DATE('','yyyymmdd')));2.子分区查询select * from MYLONG SUBPARTITION(MY__A);3.子分区信息select table_name,pa
3、rtition_name,SUBPARTITION_NAME from user_tab_subpartitions;4.11g下可以(范围-范围)CREATE TABLE mylong(MYDATE DATE,ATYPE NUMBER,ABC NUMBER)PARTITION BY RANGE(MYDATE)SUBPARTITION BY RANGE(ATYPE)SUBPARTITION TEMPLATE(SUBPARTITION "2" VALUES less than(2) TABLESPACE users, SUBPARTITION
4、"max" VALUES less than(MAXVALUE) TABLESPACE users)(PARTITION MY_ VALUES less than (TO_DATE('','yyyymmdd')),PARTITION MY_ VALUES less than (TO_DATE('','yyyymmdd')),PARTITION MY_ VALUES less than (TO_DATE('','yyyymmdd')));