ORA-12899 (value too large for column) when Importing Older Customer Dump into Agile e6.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 ***
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).
Oracle Agile e6.1 uses UTF8 database encoding.
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