My Oracle Support Banner

GoldenGate SourceIsTable Extract Not Capturing All Records In A Table And Show No Errors. (Doc ID 2625936.1)

Last updated on MAY 26, 2020

Applies to:

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

Symptoms

 In this particular case it was being noticed that SourceIsTable/Initial Load extract using SQLPREDICATE was not capturing all the records as shown by "Select count(*)" from SQLPLUS.

 

Below is the OGG version which was being used:
Version 19.1.0.0.1 OGGCORE_19.1.0.0.0_PLATFORMS_190524.2201_FBO
Linux, x64, 64bit (optimized), Oracle 12c on May 25 2019 12:43:44

 

--Output of SELECT COUNT(*)
select count(*) from TABLE where id > 2270584;
select count(0) from TABLE where id > 2270584;
select count(*) from (select 0 from TABLE where id > 2270584);

08:51:41 USER@SID>
COUNT(*)
----------
1083711

08:51:42 USER@SID>
COUNT(0)
----------
1083711

08:51:42 USER@SID>
COUNT(*)
----------
1083711

--Extract parameter used
SOURCEISTABLE
EXTFILE /TRAIL_DIR/xx
TABLE TABLE, SQLPREDICATE "WHERE ID > 2270584";

--Result from report after successful execution without any errors.
From Table TABLE:
# inserts: 790329 <=== Less than 1083711 as reported by "SELECT COUNT(*)"
# updates: 0
# deletes: 0
# upserts: 0
# discards: 0

Cause

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
Symptoms
Cause
Solution


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