-
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
-
any thoughts or recommendations?
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|