My Oracle Support Banner

How to Exclude Empty Transactions From GoldenGate Extract Capture? (Doc ID 1389353.1)

Last updated on JANUARY 23, 2020

Applies to:

Oracle GoldenGate - Version 10.0.0.0 and later
Information in this document applies to any platform.

Goal

How can empty transactions be excluded from Oracle GoldenGate (OGG) extract capture ?

 
For example, when an extract shows an empty transaction in the SEND EXTRACT SHOWTRANS output, how can you exclude this transaction other than manually interfering with SEND EXTRACT excdr, skipTRANS command ?
 

 

GGSCI> SEND EXTRACT <extract_name>, SHOWTRANS
Example:
XID: 7.43.652
Extract: ETEST
Items: 0 <----------------
Start Time: 2009-02-09:13:46:44
SCN: 0.1764307

Solution

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
Goal
Solution

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