Database Utilities (MOSC)

MOSC Banner

ORA-12899: value too large for column during import

edited Mar 8, 2013 4:30AM in Database Utilities (MOSC) 4 commentsAnswered ✓
Hello.

I am copying some tables from one 11.2.03 database to another 11.2.0.3. When running the import I have encountered these errors
ORA-12899: value too large for column RET_STR_NM (actual: 29, maximum: 26)
ORA-12899: value too large for column RET_STR_NBR (actual: 16, maximum: 15)

I have confirmed that both tables have these columns as varchar2(26) and varchar2(15) in both target and source databases. so there is no way a 29 char string can be inserted on the source side.

I have also confirmed that the nls_charactersets are different  - WE8ISO8859P1 on the source and AL32UTF8 on the target. Could this be the root cause of the issue? And if so, how can I prove it?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center