My Oracle Support Banner

Name-Length Limitations for Database Constraints in ODI and Related Technologies (Doc ID 424427.1)

Last updated on NOVEMBER 20, 2023

Applies to:

Oracle Data Integrator - Version 3.2.03.01 to 10.1.3.6.0
Information in this document applies to any platform.

Goal

In all standard prepackaged Control Knowledge Modules in ODI, the error table, (E$_ ) CONS_NAME column for storing constraint names is 35 characters long by default.

This does not pose any problem when inserting the constraint from the Oracle Data Integrator (ODI) Designer as the GUI constraint field limit is 35.

No problems will be encountered with Oracle and Teradata Datastores as these Databases impose limiting values of less than 35.

However, this is not the case when using Microsoft SQLServer using a table with a constraint name which exceeds 35 characters in length. In this case an error message will be signalled when populating the E$_ table during execution of an Integration Interface.

Is there a workaround ?

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.