ORA-12899: value too large for column
Posted on 2011-03-09
As to the length issues, these are fields with special characters in them. When we unload them from Informix they are put in the file as a special character. When you vi the file it appears as \nnn which is the octal representation of the character. For example, in the cf_borr file we have an e-mail address that looks like:
In Informix the length of this field is 49 because the two special characters are counted as one byte. When we load this into Oracle we get the error:
ORA-12899: value too large for column "RDDBA"."CF_BORR"."BORR_EMAIL_ADR" (actual: 51, maximum: 50)
In reality the value is only 49 characters with the 2 special characters (47 + 2 special = 49). Maybe Oracle is counting the speical characters as two bytes (47 + 2*2 = 51)? After looking at several of these data files this appears to be the most prevelant problem. Any ideas?