How to fix the Oracle error ORA-14272: only a partition with higher bound can be reused?

In this post, you’ll learn more about the Oracle ErrorORA-14272: only a partition with higher bound can be reused with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-14272: only a partition with higher bound can be reused

Reason for the Error ORA-14272: only a partition with higher bound can be reused

User attempt to reuse a lower-bound partition in ALTER TABLE MERGE PARTITIONS statement as the resulting partition which is illegal.

How to fix the Error ORA-14272: only a partition with higher bound can be reused ?

You can fix this error in Oracle by following the below steps

Use the higher-bound partition to be the resulting partition or specify a new partition name