exp时EXP-00091: 错误的处理

EXP-00091: Exporting questionable statistics 问题处理方法

在使用EXP导出数据的时候报“EXP-00091: Exporting questionable statistics”错误，以下是处理方法：

1.问题现象
bash-3.2$  exp bd/bd file=bd.dmp log=bd.log
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Tes
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)


About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user BD 
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user BD 
About to export BD's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export BD's tables via Conventional Path ...
. . exporting table              BS_EXCE_BILL_RULE          1 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table                GUHX_PROM_PRICE       1358 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                        LPQ_TMP        972 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table             OB_DATABASE_CONFIG         12 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table               OB_SERVER_CONFIG         12 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table      RS_ALL_LOCAL_MSC_EXCHANGE          0 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table     RS_BILLING_RECORD_TYPE_DEF          0 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table                 RS_BORDER_ROAM          0 rows exported
…….............……

2.该错误的原因是因为我们exp工具所在的环境变量是的NLS LANG中的NLS_CHARCATERSET不一致引起的。

  处理如下：

1）查询数据库的字符集
   SQL> select userenv('language') from  dual;


USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.AL32UTF8

2）在Linux操作系统下的NLS_LANG环境变量设置
bash-3.2$export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

   在Window系统下的环境变量的修改方法是：
   C:\>set NLS_LANG=AMERICAN_AMERICA.AL32UTF8

   再进行EXP导出操作就不会报这个错误了