In previous post I wrote about splitting single partition into two or more partitions. In this post we will see how we can merge two or more partitions into single partition and can reduce the overhead of managing multiple partitions.

To read split partitions

Here we will see example of merging different types of partiitons.

1.Merging Range Partitions :

2.Merging List Partitions

3.Merging Interval Partitions :

4.Merging *-hash Partitions :

We can merge any range-hash , list-hash , interval-hash partitions. Here I took example of list-hash partitioned table.

5.Merging *-list Partitions :

We can merge any range-list , list-list ,interval-list partitions. Here I took example of list-list partitioned table.

6.Merge *-range partitions :

We can merge any list-range , range-range , interval-range partition. Here I took example of list-range partitioned table.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.