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

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

Oracle Error Message

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

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

Solution

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

Share:

Leave a Reply

You May Also Like

Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...