aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

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

OCI-22278: must update the LOB only through the LOB buffers
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.

请先 登录 后评论

1 个回答

小智
OCI-22278:只能通过LOB缓冲区更新LOB,
.原因:为此LOB启用了LOB缓冲,并且缓冲池中有这个LOB的缓冲区。因此,不允许通过除了LOB缓冲器之外的手段来更新LOB。,
.操作:使用启用了LOB缓冲区的定位器通过LOB缓冲区更新LOB。如果需要此操作,则应根据需要刷新与此LOB关联的缓冲区,否则应禁用缓冲。一旦完成,重新发出命令。,
.
请先 登录 后评论