ORA-28671: UPDATE BLOCK REFERENCES may not be used on a
partitioned index as a whole



ORA-28671: UPDATE BLOCK REFERENCES may not be used on a partitioned index as a whole..

Answer / guest

Cause: User attempted to UPDATE BLOCK REFERENCES on a
partitioned index using ALTER INDEX UPDATE BLOCK REFERENCES
statement, which is illegal.

Action: Issue a partition level operation with ALTER INDEX
.. PARTITION .. UPDATE 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

ORA-14135: a LOB column cannot serve as a partitioning column

1 Answers  


DRG-52104: the Oracle Text environment could not initialize

1 Answers  


ORA-16116: no work available

1 Answers  


TNS-12515: TNS:listener could not find a handler for this presentation

1 Answers  


PLS-00161: Pragma string expects 3rd argument to be an identifier or a string literal

1 Answers  






ORA-13643: The task can not be interrupted or cancelled.

1 Answers  


ORA-07703: error in archive text: need '/' after device type

1 Answers  


ORA-19729: File string is not the initial version of the plugged in datafile

1 Answers  


ORA-23480: Column string is not a top-level column of "string"."string".

1 Answers  


RMAN-12009: command aborted because some backup pieces could not be located

1 Answers  


SQL*Loader-00477: REF directive for field string requires at least two arguments

1 Answers  


ORA-12685: Native service required remotely but disabled locally

1 Answers  


Categories