Issues with exchange partition
I am on 11.2.0.1.0. I am trying to move data from a non partitioned table a partitioned table with sub partitions. I am using a 2 step process of first moving to a partitioned table without sub partitions and finally to the last table with sub partition, and then create an additional sub partition that I need. When I try the below procedure everything goes fine except that the data does not get distributed in the sub partitions. Any idea why data is not getting distributed between sub-partitions or any other approach to be successful.
Create non partitioned table and populate the data: