My Oracle Support Banner

How To Manage Text Fields With Oracle GoldenGate 12 (Doc ID 2243113.1)

Last updated on AUGUST 09, 2018

Applies to:

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

Goal

I need to manage text fields inside GoldenGate before insert the data to a Oracle Database Table.
I have a definition file that states a given field has to be 4000 chars length but some times it came with less than 1000 chars.
In that case GG fills the rest of the data with spaces. I want to get rid of the unusable part of the data.
Is that possible in GG 12?
 

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!


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