OCI-22281: cannot perform operation with an updated locator

OCI-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 18:52

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

aiaiDBA

13718043309

010-86462881

OCI-22281: cannot perform operation with an updated locator

1 个回答

相似问题