ORA 1401 inserted value too large for column on exp/imp different characterset
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA 1401 inserted value too large for column on exp/imp different characterset

  1. #1
    Join Date
    Mar 2006
    Posts
    176

    ORA 1401 inserted value too large for column on exp/imp different characterset

    Hi all

    I export the database and it was on WE8MSWIN1252, then I import it into UTF8 database and both database on 9i. and I run into errors on couple of tables with error: ORA-01401. It's b/c characterset conversion and UTF8 is single byte.

    does anyone run into this issue before and any trick or way to fix or get around?

    thanks

  2. #2
    Join Date
    Mar 2006
    Posts
    176
    any thoughts or recommendations?

  3. #3
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Use a utility called CSSCAN to scan your database to tell you what columns will need to be expanded when changing charactersets:

    http://www.oracle.com/technology//so...ion/index.html
    Assistance is Futile...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width