Skip to Main Content
Forums

Database Software

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!

ORA-12899 error when using sql loader import multibyte characters

user8877753May 24 2017 — edited May 25 2017

We have a table with a column 'DESCRIPTION' defined as nvarchar2(4000). We are trying to import data into it from data file. When the field in data file is with 4000 Chinese characters, it could not be imported. error message as below:

ORA-12899: value too large for column DESCRIPTION (actual: 4000, maximum: 4000)

Can anyone advice how to fix? thanks in advance!
This post has been answered by BluShadow on May 24 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 22 2017
Added on May 24 2017
#database-key-features, #export-import-sql-loader-external-tables
5 comments
1,512 views