My Oracle Support Banner

Lost Transactions when Using SET_EXECUTE(False) with User-Enqueued LCRs (Doc ID 469028.1)

Last updated on JANUARY 31, 2022

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2]
Information in this document applies to any platform.


Intermittently the Streams Apply process is discarding user-enqueued LCRs rather than applying them. The same Apply process has another rule associated with it for another table for which set_execute is false and the LCRs associated with that table are correctly discarded.

The presence of the other rule for which we do not want the LCRs to be executed appears to be interfering with the ability of the Apply to apply the LCRs that we do want to be applied.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.