مثال از Interval-List Partitioning

alter table A.TEST modify

partition by range (TIME1) interval(numtodsinterval(1, 'DAY')) 

subpartition by list (SERIAL1)

   subpartition template

   ( subpartition SERIAL_P1 values (110)

   , subpartition SERIAL_P2 values (111)

   , subpartition SERIAL_P3 values (112)

   , subpartition SERIAL_P4 values (113)

   )

(  

   partition TEST_P1 values less than (to_date('19-03-2019', 'DD-MM-YYYY'))  

) online update indexes parallel;