exp00091 oracle,Windows环境下EXP-00091错误的解决办法-优快云博客

在Windows环境中使用Oracle 10.2.0.5导出数据时遇到EXP-00091错误，提示统计信息有问题。错误可能是由字符集不匹配导致的。解决方法包括：修改环境变量NLS_LANG使其与数据库字符集一致或永久修改注册表中的NLS_LANG值。通过这两种方式可以避免导出数据时的警告，确保导出成功。

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

最新项目上的同事反映在使用exp导出数据时有报错(windows Server 2008+Oracle 10.2.0.564bit)，提示“EXP-00091: 正在导出有问题的统计信息。”从字面意思来看，是统计信息出了问题。通过查阅官方文档，其中对EXP-00091错误的描述及解决方案如下：

EXP-00091: Exporting questionable statistics.

Cause: Export was able export statistics, but the statistics may not be usuable. The statistics are questionable because one or more of the following happened during export: a row error occurred, client character set or NCHARSET does not match with the server, a query clause was specified on export, only certain partitions or subpartitions were exported, or a fatal error occurred while processing a table.

Action: To export non-questionable statistics,changethe client character set or NCHARSET to match the server, export withno queryclause, exportcompletetables. If desired, import parameters can be supplied so that only non-questionable statistics will be imported, and all questionable statistics will be