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

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

Oracle Error Message

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

Reason for the Error

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

Solution

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

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...