Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

merging table partitions

407048Apr 10 2005 — edited Apr 21 2005
I 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 19 2005
Added on Apr 10 2005
6 comments
668 views