11gR2 : PARTITION LIST-RANGE
I have to implement subpartitioning on a table SALES already partitioned (LIST PARTITION) : column country_cd.
The goal is to add subpartitions ( RANGE SUBPARTITION) on column SALE_DATE.
The problem is that RANGE SUBPARTITIONING does not evolve in an automatic way (not like INTERVAL in 11g)
and I am bound to add a subpartition manually each month or at least each end of the year for the following year !
Is it possible to automate this addition of sub-partitions?
Best regards.
GD.