oracle导出dmp指定字符集,ORA12899:导入.dmp文件+字符集转换

我正在用Oracle数据库服务器在ubuntu10.04上做django项目。所以我安装了：Oracle Database 10g xe universal Rel.10.2.0.1.0

cx_Oracle-5.0.4-10g-unicode-py26-1.x86_64

当我导入一个由oracle 10gr2 enterprise edition(在Windows XP上)生成的.dmp文件时，我得到的错误如下所示，可能与字符集转换(我的数据库包含希腊语)有关，我的数据没有完全同步。在> Username:

Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

Export file created by EXPORT:V10.02.01 via conventional path

import done in US7ASCII character set and AL16UTF16 NCHAR character set

import server uses AL32UTF8 character set (possible charset conversion)

export client uses EL8MSWIN1253 character set (possible charset conversion)

. . importing table "xxx"

IMP-00019: row rejected due to ORACLE error 12899

IMP-00003: ORACLE error 12899 encountered

ORA-12899: value too large for column "xxx"."xxx"."xxx" (actual: 41, maximum: 40)

and so on

我的oracle express服务器正在使用以下设置运行：NLS_CHARACTERSET AL32UTF8

NLS_DATE_LANGUAGE AMERICAN

NLS_LANGUAGE AMERICAN

NLS_LENGTH_SEMANTICS BYTE

NLS_NCHAR_CHARACTERSET AL16UTF16

NLS_NCHAR_CONV_EXCP FALSE

NLS_TERRITORY AMERICA

生成.dmp文件的数据库服务器NLS_CHARACTERSET EL8MSWIN1253

NLS_NCHAR_CHARACTERSET AL16UTF16

有人能告诉我怎么解决这个问题吗？在

谢谢你！在