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-31503: invalid date supplied for begin_date or end_date

1 Answers  


ORA-14299: total number of partitions/subpartitions exceeds the limit of 65535

1 Answers  


NID-00335: The following datafiles are not consistent:

1 Answers  


ORA-04090: 'string' specifies same table, event and trigger time as 'string'

1 Answers  


ORA-25110: NOSORT may not be used with a bitmap index

1 Answers  


RMAN-10024: error setting up for rpc polling

1 Answers  


AMD-00119: analytic workspace dimensions not specified in input

1 Answers  


ORA-25406: could not generate a connect address

1 Answers  


ORA-19907: recovery time or SCN does not belong to recovered incarnation

1 Answers  


PLS-00153: A string type may only be used as an object type attribute.

1 Answers  


RMAN-06424: error while looking up proxy copy

1 Answers  


ORA-30645: reject limit out of range

1 Answers  


Categories