Here we will see examples to add partition in all different types of partitioning methods.

1.Add Partition in Range-Partitioned table 

2.Add Partition in Hash-Partitioned table

3.Add Partition in List-partitioned table

4.Add Partition in Interval-Partitioned table

We can’t simply add partition in interval-partitioned table. But to add partition we can LOCK the last partition that will add one partition in table.

Let’s see how :

5. Add Partitions to a Composite *-Hash Partitioned Table

a.Range-Hash Partitioned table

b.List-Hash Partitioned table

6. Add Partitions to a Composite *-List Partitioned Table
a.Range-List partitioned table

b.List-List partitioned table

7.Range-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.