My Oracle Support Banner

How To Handle 30 Character Limit of Column Names in Oracle Database When Copying Models between Technologies in ODI 12c Studio (Doc ID 2291171.1)

Last updated on OCTOBER 30, 2020

Applies to:

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


Some Data Servers, such as and SAP, allow column names (attributes) to have more than 30 characters maximum. Oracle database version 12c R1 and below only allows 30 characters.

When loading data from one technology to another, one of the features offered by Oracle Data Integrator (ODI) Studio is to copy the model from one technology to the other, and then have ODI create the tables. Ie, to load data from to Oracle DB, the existing models can be copied into an Oracle model using ODI Studio.

However, this causes issues as some of the "attributes" or column names can be larger than 30 characters in, which is not allowed by Oracle.

How to truncate the attribute names intelligently and automatically so that the 30 character limit on Oracle database is respected? The column names must be unique.


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.