ORA-12899 (value too large for column) when Importing Older Customer Dump into Agile e6.1 (Doc ID 754284.1)

Last updated on AUGUST 01, 2016

Applies to:

Oracle Agile Engineering Data Management - Version 6.0.4 to 6.1.0 [Release 6.0.0 to 6.1.0]
Information in this document applies to any platform.
*** Checked for relevance 22-Dec-2011 ***
*** Checked for relevance 26-Jan-2015 ***

Symptoms

When importing an older Oracle Agile EDM (non-UTF8) customer dump into Oracle Agile e6.1, receiving error "ORA error 12899 (value too large for column)" for all tables which contain special characters. Rows containing these special characters are excluded during the import, resulting in an unusable database.
Steps To Reproduce:
1. Using export (exp) utility, create dump file from Oracle 10g database.
2. Import (imp) dump file into Oracle 11g database (UTF8 character set).

Changes

Oracle Agile e6.1 uses UTF8 database encoding.

Cause

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 hundreds of Community platforms