How to fix the Oracle error ORA-14042: partition bound may not be specified for a partition being moved, modified or rebuilt?

In this post, you’ll learn more about the Oracle ErrorORA-14042: partition bound may not be specified for a partition being moved, modified or rebuilt with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-14042: partition bound may not be specified for a partition being moved, modified or rebuilt

Reason for the Error ORA-14042: partition bound may not be specified for a partition being moved, modified or rebuilt

while parsing an ALTER {TABLE|INDEX} MODIFY PARTITION, ALTER TABLE MOVE PARTITION, or ALTER INDEX REBUILD PARTITION statement, description of new physical attributes of the partition being moved, modified, or rebuilt was found to contain VALUES LESS THAN clause which is illegal

How to fix the Error ORA-14042: partition bound may not be specified for a partition being moved, modified or rebuilt ?

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

remove VALUES LESS THAN clause from the description of new attributes of the partition being moved, modified, or rebuilt