Oracle Combined Partitioning

Because the interval partition is for the range, the 11g-12.1 version, currently only interval-* a total of 3 kinds of interval compound partition

Range-list Method:

Partition by range (UpdateTime)
Interval (numtodsinterval (1, ' Day '))
Subpartition by list (Psncode)
Subpartition TEMPLATE (
Subpartition region_1 values (' 038716 '),
Subpartition region_2 values (' 270719 '))
(partition P1 values less than (to_date (' 2014-05-01 ', ' yyyy-mm-dd '))

Note: Each partition has 2 sub-partitions, and the partition's sub-partitions need to be manually added

Interval partition is currently tested, only the range partitioning method is supported

Range-hash Method: 10 sub-hash partitions per partition (you can specify each sub-partition to a separate tablespace)

Partition by range (UpdateTime)
Interval (numtodsinterval (1, ' Day '))
Subpartition by Hash (Psncode)

Subpartition template   (subpartition p1 tablespace ts1   , subpartition p2 tablespace ts2   , subpartition P3 tabl ESPACE Ts3   , subpartition P4 tablespace ts4   )

(partition P1 values less than (to_date (' 2014-05-01 ', ' yyyy-mm-dd '))

Note: This can be achieved by fully automatic partitioning, which is ideal for large tables with more than 10-digit growth characteristics

Hash partition is best 2 of the time, otherwise the data will be distributed unevenly

Range-range Method: The sub-partition needs to be added manually, this kind of partition needs to be generally relatively rare

PARTITION by RANGE (time_id)

INTERVAL (Numtodsinterval (1, ' Day '))

Subpartition by RANGE (Amount_sold)
Subpartition TEMPLATE
(subpartition p_low VALUES less THAN (1000)
, subpartition p_medium VALUES less THAN (4000)
, subpartition P_high VALUES less THAN (8000)
, subpartition p_ultimate VALUES less THAN (maxvalue)
)
(PARTITION before_2000 VALUES less THAN (to_date (' 01-jan-2000 ', ' dd-mon-yyyy '))

Oracle Combined partition