My Oracle Support Banner

How To Modify ODI Knowledge Modules To Truncate Column Names To 30 Characters (Doc ID 1454438.1)

Last updated on OCTOBER 29, 2020

Applies to:

Oracle Data Integrator - Version and later
Information in this document applies to any platform.


In ODI, when duplicating Models from one Technology to another one (such as Oracle) where restrictions apply concerning the length of Datastore colum names such that they may not excced 30 characters, then during runtime of Integration Interfaces it appears that the related Knowledge Modules (KM) are no longer working.

More precisely, they fail with the following message:

subsequently identified as the result of columns name exceeding the maximum size length of the technology involved.

How then can the KMs such as

be modified in order to truncate the column names which are the source of the issue ?


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

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