MYDBA@ORCL >
MYDBA@ORCL >
MYDBA@ORCL >
MYDBA@ORCL > create table old_table (a number) partition by range(a)
  2  ( partition p1 values less than (10),
  3  partition p2 values less than (20),
  4  partition p3 values less than (maxvalue));

Table created.

MYDBA@ORCL > create table new_table (a number);

Table created.

MYDBA@ORCL > insert into old_table values (4);

1 row created.

MYDBA@ORCL > insert into old_table values (15);

1 row created.

MYDBA@ORCL > insert into old_table values (29);

1 row created.

MYDBA@ORCL > commit;

Commit complete.

MYDBA@ORCL > insert into new_table select * from old_table partition (p1);

1 row created.

MYDBA@ORCL > commit;

Commit complete.

MYDBA@ORCL > select * from new_table;

         A
----------
         4

1 row selected.

MYDBA@ORCL > alter table old_table drop partition p1;

Table altered.

MYDBA@ORCL > insert into new_table select * from old_table partition (p2);

1 row created.

MYDBA@ORCL > commit;

Commit complete.

MYDBA@ORCL > select * from new_table;

         A
----------
         4
        15

2 rows selected.

MYDBA@ORCL > alter table old_table drop partition p2;

Table altered.

MYDBA@ORCL > insert into new_table select * from old_table;

1 row created.

MYDBA@ORCL > commit;

Commit complete.

MYDBA@ORCL > select * from new_table;

         A
----------
         4
        15
        29

3 rows selected.

MYDBA@ORCL > drop table old_table;

Table dropped.

MYDBA@ORCL >