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 – Value too large for column string while performing import through databases with differe

LauryAug 10 2017 — edited Aug 17 2017

Hi,

I am working with Oracle RDBMS 11g for export with datapump, and Oracle RDBMS 12cR1 for import with datapump.

While doing this, I encountered the following error for some tables:

ORA-12899 – Value too large for column string

The involved databases have a different character set...

I have found this link for a work-around:

Sysadmin and DBA tips – ORA-12899 – Value too large for column string

Does someone has experience with this?

Should I convert from VARCHAR2 -> CHAR?

Why not to use a bigger different length is keep the use of VARCHAR2?

Thanks by advance for sharing your experience.

Kind Regards

This post has been answered by Gaz in Oz on Aug 13 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 14 2017

Added on Aug 10 2017

#database-key-features, #export-import-sql-loader-external-tables

7 comments

3,624 views