Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

primary key not display in trail file

C LEUNGDec 7 2023

Hi all,

I search the posts here and was not able to find a solution.

using logdump to display the insert record, it did not show the primary key.

same applies to delete record. Please advise what am I missing?

EXTRACT ext01
DISCARDFILE ./dirrpt/ext01.dsc, APPEND
EXTTRAIL /trails/et
USERIDALIAS gg
TRANLOGOPTIONS NOUSENATIVEOBJSUPPORT
TABLE XXX.*;

Definition for table XXX.TABXXX
Record Length: 4586
Columns: 6
PK 134 19 0 0 0 1 0 8 8 8 0 0 0 0 1 0 1 3 2 -1 0 0 0 <<<=== PK is primary key
VERSION 134 19 12 0 0 1 0 8 8 8 0 0 0 0 1 0 0 3 2 -1 0 0 0
XXX_KEY 64 256 24 0 0 1 0 256 256 0 0 0 0 0 1 0 0 0 1 -1 0 0 0
TS 192 29 286 0 0 1 0 29 29 29 0 6 0 0 1 0 0 0 187 -1 0 0 0
NOTES 64 256 318 0 0 1 0 256 256 0 0 0 0 0 1 0 0 0 1 -1 0 0 0
DATA 64 8000 580 0 0 1 0 4000 4000 0 0 0 0 0 1 0 0 4 113 -1 0 1 1

___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x0c)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 88 (x0058) IO Time : 2023/12/04 20:23:55.000.000
IOType : 5 (x05) OrigNode : 255 (xff)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 80006 AuditPos : 4248168
Continued : N (x00) RecCount : 1 (x01)

2023/12/04 20:23:55.000.000 Insert Len 88 RBA 2229
Name: XXX.TABXXX(TDR Index: 1)
After Image: Partition x0c G s
0000 0a00 0000 0000 0000 0000 0004 0100 0a00 0000 | .................... <---- PRIMARY KEY VALUE NO SHOW
0000 0000 0000 0004 0200 0500 0000 0100 3403 001f | ................4...
0000 0032 3032 332d 3132 2d30 343a 3230 3a32 333a | ...2023-12-04:20:23:
3436 2e30 3030 3030 3030 3030 0400 0400 ffff 0000 | 46.000000000........
0500 0400 ffff 0000 | ........

Appreciated !!!

Friendly

Comments
Post Details
Added on Dec 7 2023
2 comments
101 views