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

TNS-04063: Remote administration disabled in the Oracle Connection Manager instance.

1 Answers  


RMAN-00578: pipe string is not private and owned by SYS

1 Answers  


PCB-00226: SQL identifier "string" already defined

1 Answers  


ORA-02738: osnpwrtbrkmsg: incorrect number of bytes written

1 Answers  


ORA-08448: syntax error in DECIMAL-POINT environment clause

1 Answers  






ORA-10643: Database should be mounted in restricted mode and Exclusive mode

1 Answers  


DRG-12700: seed word must be a single word

1 Answers  


ORA-32408: materialized view log on "string"."string" already has new values

1 Answers  


ORA-40216: feature not supported

1 Answers  


ORA-12636: Packet send failed

2 Answers  


TNS-04069: Sleeping for number seconds...

1 Answers  


ORA-16089: archive log has already been registered

1 Answers  


Categories