ORA-22278: must update the LOB only through the LOB buffers



ORA-22278: must update the LOB only through the LOB buffers..

Answer / guest

Cause: LOB buffering is enabled for this LOB and there are
buffers for this LOB in the buffer pool. Thus, updating the
LOB through means other than the LOB buffers is not allowed.

Action: Update the LOB through the LOB buffers using the
locator that has LOB buffering enabled. If this operation is
required, buffers associated with this LOB should either be
flushed as necessary or buffering should be disabled. Once
this is done, 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

LPX-00303: attribute value "~S" not expected for ~S

1 Answers  


NNL-00510: Adds a data record to an existing name

1 Answers  


PLS-00563: illegal use of CAST expression

1 Answers  


ORA-31602: parameter string value "string" in function string inconsistent with string

1 Answers  


ORA-29540: class string does not exist

1 Answers  






QSM-02079: mv log must have ROWID

1 Answers  


ORA-31517: CDC change table string.string already exists

1 Answers  


PLS-01907: : number precision too large

1 Answers  


TNS-04050: Invalid specification for gateway ID.

1 Answers  


IMP-00090: Unexpected DbmsJava error number at step number while creating string

1 Answers  


SQL*Loader-00263: PIECED column string must be last specified column in table string

1 Answers  


ORA-13351: two or more rings of a complex polygon overlap

1 Answers  


Categories