EXP-00091: Exporting questionable statistics.问题解决

精选转载

axiaowuua 2013-09-27 10:24:42

文章标签 oracle 导出 exp 00091 文章分类 Oracle 数据库

对DBA或需使用exp,imp的普通用戶來说，在我们做exp的过程中可能经常会遇到EXP－00091Exportingquestionablestatistics.这样的EXP信息，

其实它就是exp的errormessage，它产生的原因是因为我们exp工具所在的环境变量中的NLS_LANG与DB中的NLS_CHARACTERSET不一致。

问题：

lpding->expscott/scottfile=/oracle/exp/scott_emp.dmplogscott_emp.logtables=emp

Export:Release10.2.0.1.0-ProductiononTueJun2915:07:382010

Connectedto:OracleDatabase10gEnterpriseEditionRelease10.2.0.1.0-Production
WiththePartitioning,OLAPandDataMiningoptions
ExportdoneinUTF8charactersetandAL16UTF16NCHARcharacterset
serverusesZHS16GBKcharacterset(possiblecharsetconversion)

AbouttoexportspecifiedtablesviaConventionalPath...
..exportingtableEMP14rowsexported
EXP-00091:Exportingquestionablestatistics.
EXP-00091:Exportingquestionablestatistics.
Exportterminatedsuccessfullywithwarnings.

解决：

SQL>select*fromv$nls_parameterswhereparameter='NLS_CHARACTERSET';

PARAMETERVALUE
----------------------------------------------------------------------------------------------------------------------------------
NLS_CHARACTERSETZHS16GBK

SQL>host
lpding->exportNLS_LANG=AMERICAN_AMERICA.ZHS16GBK--修改会话的字符集

再进行导出，此时会话字符集与服务端字符集保持一致，导出时不会再出来exp-00091的报错提示，问题解决。

lpding->expscott/scottfile=/oracle/exp/scott_emp.dmplogscott_emp.logtables=emp

Export:Release10.2.0.1.0-ProductiononTueJun2915:32:082010

Connectedto:OracleDatabase10gEnterpriseEditionRelease10.2.0.1.0-Production
WiththePartitioning,OLAPandDataMiningoptions
ExportdoneinZHS16GBKcharactersetandAL16UTF16NCHARcharacterset

AbouttoexportspecifiedtablesviaConventionalPath...
..exportingtableEMP14rowsexported
Exportterminatedsuccessfullywithoutwarnings