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 250
partitions..namely
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 ?
Best Answer
You can just easily loop through the partitions in a PL/SQL loop, and add the subpartitions: