Subpartition by range with interval per DAY
I want to create a composite(list-range) partition table with subpartition by range (interval per day).
But I'm not sure that interval functionallity works for subpartition tables.
This is the statement:
create table table_partition
(
campo1 varchar2(100),
campo2 number,
estado varchar2(100),
fecha date
)
partition by list (estado)
subpartition by range (fecha)
INTERVAL (NUMTODSINTERVAL(1,'DAY'))
(
partition part1 values(0)(subpartition fecha1 values less than (to_date('01/01/2012','dd/mm/yyyy', 'NLS_CALENDAR=GREGORIAN'))),
partition part2 values(10)(subpartition fecha2 values less than (to_date('01/01/2012','dd/mm/yyyy', 'NLS_CALENDAR=GREGORIAN'))),
partition part3 values(90)(subpartition fecha3 values less than (to_date('01/01/2012','dd/mm/yyyy', 'NLS_CALENDAR=GREGORIAN')))