EXP-00091: Exporting questionable statistics.问题解决！(转)

最新推荐文章于 2021-04-15 00:25:22 发布

原创最新推荐文章于 2021-04-15 00:25:22 发布 · 384 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Oracle #SQL Server #SQL #C #C++

oracle 专栏收录该内容

29 篇文章

订阅专栏

本文介绍了解决Oracle导出过程中出现的EXP-00091错误的方法。该错误通常由环境变量NLS_LANG与数据库NLS_CHARACTERSET设置不一致引起。通过调整环境变量设置可以有效避免字符集转换导致的问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

对DBA或需使用exp,imp的普通用戶來说，在我们做exp的過程中可能经常会遇到EXP－00091 Exporting questionable statistics.这样的EXP信息，其实它就是exp的error message，它产生的原因是因为我们exp工具所在的环境变量中的NLS_LANG与DB中的NLS_CHARACTERSET不一致。

问题：

lpding-> exp scott/scott file=/oracle/exp/scott_emp.dmp log scott_emp.log tables=emp

Export: Release 10.2.0.1.0 - Production on Tue Jun 29 15:07:38 2010

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in UTF8 character set and AL16UTF16 NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)

About to export specified tables via Conventional Path ...
. . exporting table EMP 14 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.

解决：

SQL> select * from v$nls_parameters where parameter='NLS_CHARACTERSET';

PARAMETER VALUE
------------------------------- ---------------------------------------------------------------------------------------------------
NLS_CHARACTERSET ZHS16GBK

SQL> host
lpding-> export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
lpding-> exp scott/scott file=/oracle/exp/scott_emp.dmp log scott_emp.log tables=emp

Export: Release 10.2.0.1.0 - Production on Tue Jun 29 15:32:08 2010

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table EMP 14 rows exported
Export terminated successfully without warnings.
lpding->