My Oracle Support Banner

The Column Case Change From Lower To Upper After Upgrading OGG Version From 12.3 To 19.1 (Doc ID 2683888.1)

Last updated on JUNE 24, 2020

Applies to:

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

Goal

The table structure in the trail file will be changed from 12.3 to 19.1.
in the 12.3 the column is lower case and sync to kafka ,the JSON will record the lower case table structure.
But after upgrading to 19.1 and specify the trail file format to 12.3.
The column case will change upper case, and sync to KAFKA, the JSON will record the upper case table structure, It can't recognize this table's column again.
is there any other default changes from 12.3 to 19.1??
 

Solution

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
Goal
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.