Database DataWarehousing (MOSC)

MOSC Banner

Range partiition - split a single partition into many partitions oracle 10g

edited May 22, 2012 8:00AM in Database DataWarehousing (MOSC) 4 comments
DB: Oracle 10.2.0.4OS: Linux
RAC DB

I am looking for a syntax help where I don't have to split one partition at a time and will be able to split all 14 months of partitions in  one go.

i have the following partitions in a table DIS_CONTROL and need to know if I could split the most recent partition  DIS_CNTRL_MAX into P_201101, P_201102, P_201103..........P_201201,P_201202, P_201203,P_201204, ect.  the DIS_CNTRL_MAX have data for entire 2011 and 01/2012,  02/2012, 03/2012 and 04/2012.


right now, the following partitions exist in the DIS_CONTROL  table:

DIS_CNTRL_MAX
P_201012
P_201011
P_201010
P_201009
P_201008

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