I believe adding sub-partition in
Oracle 11g is easy
ALTER TABLE PART_TEST modify partition OCT19 add subpartition OCT19AXCS values ('AXCS');
I have close to
jan07 feb07 ... up till ... dec26
Does it mean I need to include that many alter table statements to alter all my partitions and add sub-partitions ?