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-19769: missing FILE keyword

1 Answers  


ORA-00109: invalid value for attribute string: string

1 Answers  


QSM-01101: rollup(s) took place on mv, string

1 Answers  


PLS-00714: supertypes's AUTHID is DEFINER but supertype and subtype are not in same schema

1 Answers  


ORA-06138: NETTCP: error during connection handshake

1 Answers  


ORA-03283: specified datafile string does not exist

1 Answers  


IMG-00855: internal image index free failed

1 Answers  


PLS-01703: Cursor name in CLOSE statment must be of length 1

1 Answers  


DRG-12604: execution of user datastore procedure has failed

1 Answers  


ORA-27208: syntax error in device PARMS - environment variable value missing

1 Answers  


RMAN-06462: no backupsets found on device DISK that match specification

1 Answers  


SQL-02157: Source or destination lob is invalid

1 Answers  


Categories