Range partiition - split a single partition into many partitions oracle 10g
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:
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 |
0