SQL & PL/SQL

Hi folks,
I have a table with millions of rows of data and is range-list partitioned as follows:

PARTITION ---------------- SUB-PARTITION*

part_ran1-------------------sub_part_list1a
part_ran1-------------------sub_part_list1b

part_ran2-------------------sub_part_list2a
part_ran2-------------------sub_part_list2a

now I want to remove all the sub-partitions and have a partitioned structure of the table as follows:

PARTITION---------------- SUB-PARTITION*
part_ran1
part_ran2

I cannot drop the partitions as my data is very critical.
so i decided to merge the subpartitions. I managed to get a partitioned structure of the table as follows:

PARTITION---------------- SUB-PARTITION*

part_ran1-------------------sub_part_final1
part_ran2-------------------sub_part_final2

now what do i do to remove the sub-partiitons :sub_part_final1 ; sub_part_final2

Plz Help... Thnx in advance!!!!

Edited by: Commander on Jan 12, 2009 7:44 PM