Question
Hi,
I have a requirement where I need to do interval subpartition over a table. but there is an oracle limitation on interval subpartition. how can I achieve this? below is the example.
Create table CARS (auto_make varchar(30),
Auto_model varchar(30),
Purchase_date date)
PARTITION BY LIST (auto_make)
SUBPARTITION BY RANGE (Purchase_Date) interval (NUMTOYMINTERVAL(1,'month'))
SUBPARTITION TEMPLATE
(subpartition sp1 values less than
TO_DATE('15-03-2015','dd-mm-yyyy'))
(partition p_vw values ('JETTA'));
Error report -
SQL Error: ORA-14179: An unsupported partitioning method was specified in this context.
14179. 00000 - "An unsupported partitioning method was specified in this context."
*Cause: An attempt was made to specify an unsupported partitioning method in this context.
*Action: Remove the invalid option.
Thanks in advance.