ORA-22281: cannot perform operation with an updated locator

ORA-22281: cannot perform operation with an updated locator
Cause: The input locator has buffering enabled and was used to update the LOB value through the LOB buffering subsystem. The modified buffer has not been flushed since the write that was performed by the the input locator; thus, the input locator is considered an updated locator. Updated locators cannot be the source of a copy operation. Only one locator per LOB may be used to modify the LOB value through the LOB buffering subsystem.
Action: Depending on whether the modifications made through the input locator to the LOB buffering subsystem should be written to the server, either flush the buffer to write the modifications, or, disable buffering on the locator to discard the modifications. Then, reissue the command.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:44

ORA-22281：无法使用更新的定位器执行操作,
.原因：输入定位器已启用缓冲区，并且用于通过LOB缓冲子系统更新LOB值。自从由输入定位器执行的写入之后，修改的缓冲器尚未被刷新; 因此，输入定位器被认为是更新的定位器。更新的定位器不能是复制操作的源。每个LOB只有一个定位器可以用于通过LOB缓冲子系统修改LOB值。,
.操作：根据通过输入定位器到LOB缓冲子系统进行的修改是否应写入服务器，刷新缓冲区以写入修改，或者禁用定位器上的缓冲区以丢弃修改。然后，重新发出命令。,
.

aiaiDBA

13718043309

010-86462881

ORA-22281: cannot perform operation with an updated locator

1 个回答

相似问题