OGG EXTRACT NOT CAPTURING ALL COLUMN VALUES FOR DELETE in V11.2 (Doc ID 1485135.1)

Last updated on SEPTEMBER 05, 2012

Applies to:

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

Symptoms

Even when having the ALL column table level logging and NOCOMPRESSDELETES, the v11.2.1.x ogg extract will not capture all the column values for a delete when the LAST column is NULL.
The extract captured the record correctly when using using old versions but failed in OGG v11.2.x.

 

 
TEST CASE
1)    Create table
CREATE TABLE "PJACOB"."WORK_TYPE"
   (    "WORK_CODE" VARCHAR2(3) NOT NULL ENABLE,
        "WORK_CODE_DESC" VARCHAR2(60),
        "ASSIGNMENT_ID" NUMBER,
         CONSTRAINT "PK_WORK_TYPE" PRIMARY KEY ("WORK_CODE"));
 
2)    Enable the ALL column logging
alter table PJACOB.WORK_TYPE add supplemental log data (all) columns;
 
3)    Create the extract and start it with begin now
EXTRACT EXTWH
USERID pjacob, PASSWORD xxxx
DISCARDFILE ./dirrpt/EXTWH.dsc, PURGE
NOCOMPRESSDELETES
EXTTRAIL ./dirdat/op
TABLE pjacob.WORK_TYPE;
 
4)    Do the following DMLs
insert into work_type values ('TST','TEST FOR ORACLE','');
delete from work_type where work_code = 'TST';

5) The logdump does not show the last column

2012/07/25 12:19:38.000.000 Delete               Len    34 RBA 1256
Name: PJACOB.WORK_TYPE
Before Image:                                             Partition 4   G  s  

 0000 0007 0000 0003 5453 5400 0100 1300 0000 0f54 | ........TST........T  
 4553 5420 464f 5220 4f52 4143 4c45                | EST FOR ORACLE  
Column     0 (x0000), Len     7 (x0007)  
 0000 0003 5453 54                                 | ....TST  
Column     1 (x0001), Len    19 (x0013)  
 0000 000f 5445 5354 2046 4f52 204f 5241 434c 45   | ....TEST FOR ORACLE 

 

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms