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

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:41

ORA-14042：可能未对正在移动，修改或重建的分区指定分区绑定,
.原因：在解析ALTER {TABLE | INDEX}修改分区，ALTER TABLE MOVE PARTITION或ALTER INDEX REBUILD PARTITION语句时，发现正在移动，修改或重建的分区的新物理属性的描述包含VALUES LESS THAN子句是非法的,
.操作：从正在移动，修改或重建的分区的新属性的描述中删除VALUES LESS THAN子句,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题