In Oracle 11g, is there a way to introduce subpartitions into an existing partitioned table?
I cannot seem to find a combination of
SPLIT partition that does the right thing. SPLIT will split a partition into multiple partitions, not introduce subpartitions. Any suggestions?
I did find an existing post on partitioning an existing non-partitioned table by exchanging to a table with one partition and then using SPLIT, but can't figure out the equivalent process for subpartitions. Thanks!