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

NNL-00211: Cache checkpoint interval is now string

1 Answers  


TNS-00125: Failed to get number of Interchanges in TNSNET.ORA

1 Answers  


ORA-01276: Cannot add file string. File has an Oracle Managed Files file name.

1 Answers  


ORA-16047: DGID mismatch between destination setting and standby

1 Answers  


ORA-16064: remote archival is disabled by another instance

1 Answers  






ORA-24047: invalid agent name string, agent name should be of the form NAME

1 Answers  


ORA-22628: OCIAnyData already constructed

1 Answers  


ORA-32144: Cannot perform operation on a null interval

1 Answers  


ORA-22921: length of input buffer is smaller than amount requested

1 Answers  


TNS-00296: Stoppable : string

1 Answers  


ORA-02190: keyword TABLES expected

1 Answers  


ORA-14605: Name missing for subpartition / lob segment in template

1 Answers  


Categories