Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle : ORA-12899: value too large for column

791463Aug 14 2010 — edited Aug 14 2010

Hi Experts,

I am loading multibyte data from fixed width flat file to Oracle database(which is a utf8 characterset) via Informatica. I have set utf8 as characterset in both source and target definitions.

Source flat file data : MÃ¼nchener(this flat file data was loaded from external oracle database where data looks like Münchener)

When I load the data I am getting below error

ORA-12899: value too large for column "schema_name"."table"."column" (actual: 513, maximum: 512)

I know we can declare the data type as varchar2(512 char) instead of varchar2(512 byte). Please let me know the other solution to load multibyte data into target utf8 database.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 11 2010

Added on Aug 14 2010

#general-database-discussions, #oracle

2 comments

1,732 views