windows下sqlplus或exp/imp显示乱码解决。

导入时状态如下：

Import: Release 10.2.0.3.0 - Production on 星期五 5月 4 09:22:12 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

经由常规路径由 EXPORT:V10.02.01 创建的导出文件
即将导入可传输的表空间元数据...
已经完成 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集中的导入
导入服务器使用 US7ASCII 字符集 (可能的字符集转换)
导出客户机使用 US7ASCII 字符集 (可能的字符集转换)
. 正在将 SYS 的对象导入到 SYS
. 正在将 SYS 的对象导入到 SYS
IMP-00017: 由于 ORACLE 错误 29345, 以下语句失败:
 "BEGIN   sys.dbms_plugts.beginImport ('10.2.0.1.0',31,'2000',10,'Linux IA (3"
 "2-bit)',56303,70701,2,0,0,0); END;"
IMP-00003: 遇到 ORACLE 错误 29345
ORA-29345: ??????????????????????
ORA-06512: ? "SYS.DBMS_PLUGTS", line 2386
ORA-06512: ? "SYS.DBMS_PLUGTS", line 1946
ORA-06512: ? line 1
IMP-00000: 未成功终止导入

c:\oracle>sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.3.0 - Production on 星期五 5月 4 09:22:28 2012

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select tab1.aa||'_'||tab2.bb||'.'||tab3.cc from
  2  (select VALUE$ aa from sys.props$ where name='NLS_LANGUAGE')tab1,
  3  (select VALUE$ bb from sys.props$ where name='NLS_ISO_CURRENCY')tab2,
  4  (select VALUE$ cc from sys.props$ where name='NLS_CHARACTERSET')tab3;

TAB1.AA||'_'||TAB2.BB||'.'||TAB3.CC
--------------------------------------------------------------------------------
AMERICAN_AMERICA.US7ASCII

检查发现机器环境变量设置为NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK
可临时修改环境变量，或修改注册表可解决

SQL> exit
从 Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options 断开

c:\oracle>set NLS_LANG=AMERICAN_AMERICA.US7ASCII

解决后：

Export file created by EXPORT:V10.02.01 via conventional path
About to import transportable tablespace(s) metadata...
import done in US7ASCII character set and AL16UTF16 NCHAR character set
. importing SYS's objects into SYS
. importing SYS's objects into SYS
IMP-00017: following statement failed with ORACLE error 29345:
 "BEGIN   sys.dbms_plugts.beginImport ('10.2.0.1.0',31,'2000',10,'Linux IA (3"
 "2-bit)',56303,70701,2,0,0,0); END;"
IMP-00003: ORACLE error 29345 encountered
ORA-29345: cannot plug a tablespace into a database using an incompatible character set
ORA-06512: at "SYS.DBMS_PLUGTS", line 2386
ORA-06512: at "SYS.DBMS_PLUGTS", line 1946
ORA-06512: at line 1
IMP-00000: Import terminated unsuccessfully

c:\oracle>