My Oracle Support Banner

FILTERDUPTRANSACTIONS Parameter Does Not Work (Doc ID 2202064.1)

Last updated on NOVEMBER 17, 2016

Applies to:

Oracle GoldenGate - Version to [Release 11.2 to 12.1]
Information in this document applies to any platform.


FILTERDUPTRANSACTIONS causes Replicat to ignore transactions that it has already processed.
Use when Extract was repositioned to a new start point (see the ATCSN or AFTERCSN option of "START EXTRACT") and you are confident that there are duplicate transactions in the trail that could cause Replicat to abend.

But with FILTERDUPTRANSACTIONS, Replicat does not ignore transactions that it has already processed.


FILTERDUPTRANSACTIONS Parameter is introduced on OGG
And on OGG, "_csnfiltering on" is also required to use FILTERDUPTRANSACTIONS.
On OGG 12.1.2 or above, "_csnfiltering on" is default, and you do not have to "_csnfiltering on" for FILTERDUPTRANSACTIONS.


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.