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

ORA-03297: file contains used data beyond requested RESIZE value

1 Answers  


ORA-24271: translation type must be either T, S or M

1 Answers  


ORA-24128: partition name specified for a non-partitioned object

1 Answers  


ORA-06748: TLI Driver: cannot allocate t_discon

1 Answers  


ORA-24313: user already authenticated

1 Answers  






ORA-32312: cannot refresh a secondary materialized view "string"."string"

1 Answers  


ORA-33058: (XSAGDNGL28) In AGGMAP workspace object, error code string is greater than the maximum error code of number.

1 Answers  


ORA-23469: %s is different between templates

1 Answers  


RMAN-03037: Spooling started in log file: string

1 Answers  


ORA-07410: slpdtb: number too large for supplied buffer.

1 Answers  


RMAN-05016: failover to previous backup

1 Answers  


ORA-19903: test recovery not allowed when recovering to new incarnation

1 Answers  


Categories