Database Administration (MOSC)

MOSC Banner

data on max partition

edited Jul 15, 2015 10:00AM in Database Administration (MOSC) 4 commentsAnswered

Hello Experts,

we have a table defined as range partition by trans_dt, we have created partition up to Apr and we did not created rest of the partitions. now data is going to max partition.  i am looking for solution, insite , help to move data  from max partition to corresponding month partitions?

ie, need to move April data from max partition to April  partition.

what is the best way to do it. please advice.

Tagged:

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