Windows / Oracle Database dump (exp/imp) with different charset resulting in ora-1401 error
Posted on 2006-03-22
Hello I'd like to move a database from one oracle DBMS to another (from 8.1.7 to 9.0.2)
I'm using exp/imp that is working fine though during the import I get the ora-1401 error because on the source I'm using the WE8ISO8859P1 charset and on the target I'm using UTF-8. The involved umlauts are giving me the above error: ORA-01401: inserted value too large for column
So what do I have to do, to get those 200 tables resulting in 500MB data converted and imported on the target database properly?