Oracle Database Discussions

Is it possible to merge more than 2 partitions into a single partition?

I had created the following partitions OO_TBL_P_CH,OO_TBL_P_BE,OO_TBL_P_IT,OO_TBL_P_FR,OO_TBL_P_FI,OO_TBL_P_DK,OO_TBL_P_NL,OO_TBL_P_NO,OO_TBL_P_OTHER.

But since other than the partition OO_TBL_P_IT none of them have data, it causing performance issues.

So i need to get rid of all the partitions without any data loss. Any ideas as to how i can do that?

when i execute the following i get the error
ORA 14012 the resulting partition name conflicts with existing one.


ALTER TABLE OO_TBL
MERGE PARTITIONS OO_TBL_P_CH, OO_TBL_P_BE
INTO PARTITION OO_TBL_P_OTHERS;

ALTER TABLE OO_TBL
MERGE PARTITIONS OO_TBL_P_DK, OO_TBL_P_NL
INTO PARTITION OO_TBL_P_OTHERS;

ALTER TABLE OO_TBL
MERGE PARTITIONS OO_TBL_P_NO, OO_TBL_P_FI
INTO PARTITION OO_TBL_P_OTHERS;

ALTER TABLE OO_TBL
MERGE PARTITIONS OO_TBL_P_FR, OO_TBL_P_SE
INTO PARTITION OO_TBL_P_OTHERS;

ALTER TABLE OO_TBL
MERGE PARTITIONS OO_TBL_P_OTHER,OO_TBL_P_IT
INTO PARTITION OO_TBL_P_OTHERS;