Subpartition Interval Range
Is possible create a composite partition table (list-range) with the subpartition range with interval per day feature?
When I tried to create the table this error was generated?
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')))