My Oracle Support Banner

Informix Extract : Data Is getting trimmed In Trail File (Doc ID 3037746.1)

Last updated on AUGUST 08, 2024

Applies to:

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

Symptoms

From Informix to Oracle replication, observed that values are getting trimmed for some particular columns.

Ex. In Source Values is like -- 78400
  In target Values is like -- +784

-- Below are the list of Columns in which values are getting trimmed as compared to source.

Source Columns Details with Datatype: (Informix)
+++++++++++++++++++++++++++++

C1 interval minute(5) to minute
C2 interval minute(9) to minute 

Target Columns details with Datatype : (Oracle)
+++++++++++++++++++++++++

C1 CHAR(765 CHAR) COLLATE "USING_NLS_COMP",
C2 CHAR(765 CHAR) COLLATE "USING_NLS_COMP", 

..............

 

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