Friday 11 May 2012

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

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

No comments:

Post a Comment