merging table partitions
407048Apr 10 2005 — edited Apr 21 2005I used to have 10 partitions for a table PART1, PART2.....PART9,PART10
But due to some partition splits, and drops, I have now only PART3 and PART10. And I have a requirement to merge these 2 partitions into PART10
when i tried
ALTER TABLE TABLE_NAME MERGE PARTITIONS PART3,PAR10 INTO PARTITION PART10, it is preventing me to do so saying that PART3 and PART10 are not adjacent to each other. How can I achieve my requirement here, which is to merge those 2 non-adjacent partitions ?
Thanks