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..

Answer / guest

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PCC-02361: Use of ARRAYLEN with SQL bind arrays is ignored

1 Answers  


ORA-29508: query derived from USING clause did not select a value of type string

1 Answers  


TNS-12159: TNS:trace file not writeable

1 Answers  


ORA-02852: Invalid critical-section time out value

1 Answers  


ORA-15043: ASM disk "string" is not a diskgroup member

1 Answers  






ORA-00026: missing or invalid session ID

1 Answers  


NNO-00601: warning: no forwarders, DEFAULT-FORWARDERS-ONLY mode ignored

1 Answers  


ORA-08317: sllfsk: Error seeking in file.

1 Answers  


ORA-19206: Invalid value for query or REF CURSOR parameter

1 Answers  


ORA-07713: sksamtd: could not mount archival device (SYS$MOUNT failure)

1 Answers  


LPX-00283: document encoding is ~s-based but default input encoding is not

1 Answers  


ORA-12070: cannot offline instantiate materialized view "string"."string"

1 Answers  


Categories