SQL Language (MOSC)

MOSC Banner

Issues with exchange partition

edited Feb 4, 2015 3:47PM in SQL Language (MOSC) 1 commentAnswered ✓

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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center