eygle 谢谢
改成utf8可行吗?因为我从US7ASCII库了里导出的应该是GB的编码。我试过了
ZHS16CGB231280, UTF8, 都不行。
报错:
D:\impexp>imp parfile=eecol_imp.par
Import: Release 8.1.6.0.0 - Production on Tue Dec 7 11:16:08 2004
(c) Copyright 1999 Oracle Corporation.All rights reserved.
Connected to: Oracle9i Release 9.2.0.5.0 - Production
JServer Release 9.2.0.5.0 - Production
Export file created by EXPORT:V08.01.06 via conventional path
Warning: the objects were exported by WWW_EE, not by you
import done in ZHS16CGB231280 character set and UTF8 NCHAR character set
import server uses UTF8 character set (possible charset conversion)
IMP-00069: Could not convert to environment national character set's handle
IMP-00000: Import terminated unsuccessfully
文件改到gb2312(352),NLS_LANG改到utf8。报错
D:\impexp>imp parfile=eecol_imp.par
Import: Release 8.1.6.0.0 - Production on Tue Dec 7 11:21:30 2004
(c) Copyright 1999 Oracle Corporation.All rights reserved.
Connected to: Oracle9i Release 9.2.0.5.0 - Production
JServer Release 9.2.0.5.0 - Production
IMP-00016: required character set conversion (type 850 to 871) not supported
IMP-00000: Import terminated unsuccessfully
import done in ZHS16CGB231280 character set and UTF8 NCHAR character set
你改的有问题啊。
NLS_LANG怎么成了ZHS16CGB231280?
try:
1.exp with nls_lang = us7ascii
2.change dmp file header to 0367
3.imp with nls_lang = utf8
我改过0367。出错。
D:\impexp>
D:\impexp>imp parfile=eecol_imp.par
Import: Release 8.1.6.0.0 - Production on Tue Dec 7 11:24:23 2004
(c) Copyright 1999 Oracle Corporation.All rights reserved.
Connected to: Oracle9i Release 9.2.0.5.0 - Production
JServer Release 9.2.0.5.0 - Production
Export file created by EXPORT:V08.01.06 via conventional path
Warning: the objects were exported by WWW_EE, not by you
import done in UTF8 character set and UTF8 NCHAR character set
IMP-00069: Could not convert to environment national character set's handle
IMP-00000: Import terminated unsuccessfully
D:\impexp>echo %NLS_LANG%
AMERICAN_AMERICA.UTF8