Oracle DB Error ORA-28672 UPDATE BLOCK REFERENCES may not be used on a global index

The following is the cause of this error:

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 indexes on a partitioned IOT and a global partitioned index on a non-partitioned IOT.

Action you can take to resolve this issue: Use online index [partition] rebuild to fix the block references.

Tags: Database, Microsoft, Oracle, SQL, Software, DBMS, Error Messages, Directory

Related