ORA-22281: cannot perform operation with an updated locator



ORA-22281: cannot perform operation with an updated locator..

Answer / guest

Cause: The input locator has buffering enabled and was used
to update the LOB value through the LOB buffering subsystem.
The modified buffer has not been flushed since the write
that was performed by the the input locator; thus, the input
locator is considered an updated locator. Updated locators
cannot be the source of a copy operation. Only one locator
per LOB may be used to modify the LOB value through the LOB
buffering subsystem.

Action: Depending on whether the modifications made through
the input locator to the LOB buffering subsystem should be
written to the server, either flush the buffer to write the
modifications, or, disable buffering on the locator to
discard the modifications. Then, reissue the command.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-12466: default level is greater than the user's maximum

1 Answers  


ORA-22954: This multiset operation is not supported for this element type.

1 Answers  


PCC-02020: Preprocessor error at line number, column number, file string:

1 Answers  


ORA-09913: Malloc of dummy name failed.

1 Answers  


ORA-32022: parameter value longer than string characters

1 Answers  






ORA-12635: No authentication adapters available

1 Answers  


TNS-12600: TNS: string open failed

1 Answers  


RMAN-06560: WARNING: backup set with key number will be read number times

1 Answers  


ORA-22140: given size [string] must be in the range of 0 to [string]

1 Answers  


ORA-00281: media recovery may not be performed using dispatcher

1 Answers  


TNS-04204: Trace Assistant Internal ERROR: Couldn't Open trace file

1 Answers  


ORA-30728: maximum number of columns exceeded

1 Answers  


Categories