Wednesday, 14 March 2012

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

No comments:

Post a Comment