you can do (with EMP table as example)
Code:
create table partemp(
empno number(4) not null,
ename varchar2(10),
job varchar2(9),
mgr number(4),
hiredate date,
sal number(7,2),
comm number(7,2),
deptno number(2))
partition by range(empno)
(partition partemp6 values less than (8000))
/
alter table partemp exchange partition partemp6 with table emp
/
alter table partemp split partition partemp6
at (7000)
into (partition partemp1,
partition partemp6)
/
alter table partemp split partition partemp6
at (7200)
into (partition partemp2,
partition partemp6)
/
alter table partemp split partition partemp6
at (7400)
into (partition partemp3,
partition partemp6)
/
alter table partemp split partition partemp6
at (7600)
into (partition partemp4,
partition partemp6)
/
alter table partemp split partition partemp6
at (7800)
into (partition partemp5,
partition partemp6)
/
this should be pretty fast