How to fix the Oracle error ORA-14767: Cannot specify this interval with existing high bounds?

In this post, you’ll learn more about the Oracle ErrorORA-14767: Cannot specify this interval with existing high bounds with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-14767: Cannot specify this interval with existing high bounds

Reason for the Error ORA-14767: Cannot specify this interval with existing high bounds

The interval specified conflicts with the existing high bound for the last partition. The combination might lead to invalid dates for high bounds in the future.

How to fix the Error ORA-14767: Cannot specify this interval with existing high bounds ?

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

If this is a CREATE TABLE, try specifying a different high bound value for the last partition, or a different interval. If this is an ALTER TABLE SET INTERVAL, please choose either a different interval, or, modify the table to change the high bound for the last partition.