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

EXP-00005: all allowable logon attempts failed

1 Answers  


QSM-01062: query has one or more manual partition(s)

1 Answers  


ORA-06774: TLI Driver: error sending break mode

1 Answers  


ORA-33010: (XSAGDNGL04) Relation workspace object is duplicated in the AGGMAP workspace object.

1 Answers  


ORA-24094: invalid transformation, target type does not match that of the queue

1 Answers  






ORA-24184: transformation string.string, already exists

1 Answers  


ORA-13185: failed to generate initial HHCODE

1 Answers  


DRG-51301: error releasing dml Queue lock

1 Answers  


ORA-02145: missing STORAGE option

1 Answers   Oracle,


RMAN-08033: channel string: including datafilecopy of datafile string in backupset

1 Answers  


RMAN-06105: duplicate qualifier found in LIST command: string

1 Answers  


ORA-10906: Unable to extend segment after insert direct load

1 Answers  


Categories