Oracle Database 12c New Features

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

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


Cause:


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



Action:


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