Oracle database error code ORA-28672 – UPDATE BLOCK REFERENCES may not be used on a global index

Oracle Database Error Code ORA-28672 Description :
UPDATE BLOCK REFERENCES may not be used on a global index
Error 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.

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


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , ,
No Comment Yet   
«
»