My Oracle Support Banner

OGG v11.2 doesn't include catalog names causing issues to third party tools expecting 3 part table names in the trails (Doc ID 1632949.1)

Last updated on JUNE 05, 2019

Applies to:

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

Symptoms

 Extract uses following mapping

targetdefs ./dirdef/nzerp.def
MAP <source.table>, TARGET aaa.SYSDBA.<table>,

In 11.1 the trails have 3 part names like below matching the TARGET specification

2014/01/07 11:00:58.000.000 Insert               Len   163 RBA 1080
Name: aaa.SYSDBA.<table>

However with OGG v11.2 the trail shows only 2 part names like below even though TARGET
has 3 part mapped name

2014/01/07 11:49:38.000.000 Insert               Len   148 RBA 1029
Name: SYSDBA.<table>

Changes

 

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
Changes
Cause
Solution
References


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