Hi,
I am working with Oracle RDBMS 11g.
While importing a table from a database character set WE8MSWIN1252 to a database having a database character set AL32UTF8, I came across this error:
ORA-02374: conversion error loading table "OBA_OWNER"."OBA_TOEZICHTOBJECTEN"
ORA-12899: value too large for column KVK_HANDELSNAAM (actual: 101, maximum: 100)
ORA-02372: data for row: KVK_HANDELSNAAM : 0X'48E46E64656C736E61616D206162636465666768696A6B6C6D'
What I understand is that WE8MSWIN1252 is 8-bit character set, and that AL32UTF8 is multibyte character set.
Thus, when performing the import, the 8-bit character set is "filled up" to accomodate the multibyte character set in the target database.
But, if the 8-bit character set already "filled up", it cannot be extended to accomodate the multibyte character set and I get the above errors...
In fact, before the expoert, by just increasing the datatype from 100 to 101, I can perform the import without error.
But why 101 and not 105 or any number higher than 100?
Thanks by advance for any explanation.
Kind Regards