Using the My Oracle Support Portal (MOSC)

MOSC Banner

ODI 12c IKM-LKM cut table names in target to a max of 30 characters

edited Jun 15, 2019 5:00AM in Using the My Oracle Support Portal (MOSC) 1 commentAnswered

I'm mapping data from SQL Server to ADWCS. If I create manually a table in ADWCS I can overpass 30 characters limit.

If I run describe all_tab_columns;

I get:

Nombre          ¿Nulo?   Tipo    
OWNER           NOT NULL VARCHAR2(128)
TABLE_NAME      NOT NULL VARCHAR2(128)

But when if a run the mapping from ODI with CREATE_TARGET_TABLE=true, in the target table names gets cut to a max of 30 characters.

I think this must be a IKM or LKM configuration, how can I set up to go over that limit and be able to create long names on target from ODI executions?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center