ORA-28672: UPDATE BLOCK REFERENCES may not be used on a global index ORACLE 报错 故障修复 远程处理

文档解释

ORA-28672: UPDATE BLOCK REFERENCES may not be used on a global index

Cause: User attempted to UPDATE BLOCK REFERENCES on a global partitioned or non-partitioned index. This feature is not supported for non-partitioned or global partitioned index on a partitioned IOT and a global partitioned index on a non-partitioned IOT.

Action: Use online index [partition] rebuild to fix the block references

ORA-28672:禁止在全局索引上使用UPDATE BLOCK REFERENCES(UBR)错误。

官方解释

常见案例

一般处理方法及步骤

1.检查您正在尝试更新的全局索引,在尝试使用UPDATER BLOCK REFERENCES操作之前,

2.确保您不再尝试在全局索引上更新块引用,

3.改用其他操作或技术来更新全局索引上的块引用(例如,更改索引Location因子或使用DBMS_REDEFINITION)。


数据运维技术 » ORA-28672: UPDATE BLOCK REFERENCES may not be used on a global index ORACLE 报错 故障修复 远程处理