ORA-28671: UPDATE BLOCK REFERENCES may not be used on a partitioned index as a whole

ORA-28671: UPDATE BLOCK REFERENCES may not be used on a partitioned index as a whole
Cause: User attempted to UPDATE BLOCK REFERENCES on a partitioned index using ALTER INDEX UPDATE BLOCK REFERENCES statement, which is illegal.
Action: Issue a partition level operation with ALTER INDEX .. PARTITION .. UPDATE BLOCK REFERENCES

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:48

ORA-28671：UPDATE BLOCK REFERENCES不能在整个分区索引上使用,
.原因：用户尝试使用ALTER INDEX UPDATE BLOCK REFERENCES语句对分区索引执行UPDATE BLOCK REFERENCES，这是非法的。,
.操作：使用ALTER INDEX ..发出分区级别操作。PARTITION .. UPDATE BLOCK REFERENCES,
.

aiaiDBA

13718043309

010-86462881

ORA-28671: UPDATE BLOCK REFERENCES may not be used on a partitioned index as a whole

1 个回答

相似问题