exp00091 oracle,EXP-00091错误的说明和解决方法

我们在做EXP的过程中可能经常会遇到EXP-00091 Exporting questionable statistics的错误。

其实这个是EXP的error message，它产生的原因是因为我们EXP工具所在的环境变量中的NLS_LANG和Database中的NLS_CHARACTERSET不一致导致的。

但需要说明的是，EXP-00091这个error message对所产生的dump没有影响，生成的dump还可以正常的imp(但是最好还是再次EXP)

在oracle的doc中这样描述这个错误信息：

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, change the client character set or NCHARSET to match the server, export with no query clause, export complete tables. If des