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)。