Forum Stats

  • 3,727,614 Users
  • 2,245,418 Discussions
  • 7,852,888 Comments

Discussions

Oracle GoldenGate Extract Null Values For Primary Key Column

User_0SFG1
User_0SFG1 Member Posts: 9 Red Ribbon
edited February 11 in GoldenGate On-Premises

Hi,

Goldengate extract process extract null values for primary key column. Due to FORMATASCII parameter in extract, I' am able to read context of trail file.

Here my extract parameter file:

EXTRACT EXTXXX1

TRANLOGOPTIONS ALTARCHIVELOGDEST $arc_path

TRANLOGOPTIONS ALTARCHIVEDLOGFORMAT $arc_pattern.arc

SETENV (ORACLE_SID="ORASID")

SETENV (ORACLE_HOME = "ORA_HOME")

USERID gg, PASSWORD ****************, AES128, ENCRYPTKEY *********

-- Just in case we can't process a record we'll dump info here

DISCARDFILE $GG_HOME/dirrpt/EXTXXX1.dsc, PURGE, MEGABYTES 10

REPORTROLLOVER on sunday

FORMATASCII

EXTTRAIL $GG_HOME/dirdat/ex

TABLE SCHEMA.MY_TABLE;

ddl exclude all


And also, here my trail file context:


V,B,SCHEMA.MY_TABLE,MY_PRIMARY_KEY_COLUMN,NULL,UPDATE_COLUMN,'2020-12-23:13:19:22'

V,A,SCHEMA.MY_TABLE,MY_PRIMARY_KEY_COLUMN,NULL,UPDATE_COLUMN,'2020-12-23:13:19:22'

As you can see, subsequent values after MY_PRIMARY_KEY_COLUMN is null. How can manage them?


Extract is in classic capture mode(Thinking of to upgrade it to integrated capture).

My GoldenGate information:

Oracle GoldenGate Command Interpreter for Oracle

Version 12.3.0.1.4 OGGCORE_12.3.0.1.0_PLATFORMS_180415.0359_FBO


Database version:


Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production 0

PL/SQL Release 12.2.0.1.0 - Production 0


Thanks in advance:)!

Tagged:
Sign In or Register to comment.