Showing posts with label ORA-28672: UPDATE BLOCK REFERENCES may not be used on a global index. Show all posts
Showing posts with label ORA-28672: UPDATE BLOCK REFERENCES may not be used on a global index. Show all posts

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