导出时候遇到的exp-00091:正在导出可疑的统计信息？

显示全部楼层 · 2005-6-21 01:01:50

导出的时候语句如下：
exp systm/pwd@da file=aa.dmp full=y log=aa.log
导出时候遇到的exp-00091:正在导出可疑的统计信息
可以正常导出。我想问一下DX这个错误有的原因是什么？可能产生什么风险吗？谢谢

千问 · 2005-6-21 01:01:50

EXP-00091 Exporting questionable statistics
Cause: Export was able to export statistics, but the statistics may not be useable. 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, or export complete tables. If desired, import parameters can be supplied so that only non-questionable statistics will be imported, and all questionable statistics will be recalculated.
字符集一致马

千问 · 2005-6-21 01:01:50

最初由 xinjingcool 发布
[B]EXP-00091 Exporting questionable statistics
Cause: Export was able to export statistics, but the statistics may not be useable. 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, or export complete tables. If desired, import parameters can be supplied so that only non-questionable statistics will be imported, and all questionable statistics will be recalculated.
字符集一致马 [/B]

连接到: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
已导出 ZHS32GB18030 字符集和 AL16UTF16 NCHAR 字符集
服务器使用 ZHS16GBK 字符集 (可能的字符集转换)
即将导出整个数据库...

千问 · 2005-6-21 01:01:50

客户端字符集改一下喽

千问 · 2005-6-21 01:01:50

数据库版本?
导入到新库后重新收集统计信息即可.
没有什么风险.

千问 · 2005-6-21 01:01:50

最初由 xinjingcool 发布
[B]客户端字符集改一下喽 [/B]
数据库的安装及使用环境linuxas4+oracle9.2.0.4
通过win2000的工作机使用ssh的客户端和sqlplus来远程管理：
数据库服务器下的环境变量：
root帐户下的env:
export LANG=zh_CN.GB18030
export LANGUAGE=zh_CN.GB18030:zh_CN.GB2312:zh_CN
oracle帐户下的env:
export LANG=zh_CN.GB18030:zh_CN.GB2312:zh_CN
export LANGUAGE=zh_CN.GB18030:zh_CN.GB2312:zh_CN
export NLS_LANG=Simplified Chinese_china.ZHS16GBK
export ORA_NLS33=/opt/oracle/ora92/ocommon/nls/admin/data
我想问DX我应该改那一个呢？

千问 · 2005-6-21 01:01:50

EXP-00091: Exporting questionable statistics.

Cause
~~~~~~~
In Oracle 9i by default export attempts to include statistics in the export.
In pre Oracle 9i versions statistics are not included unless it is specified.

Fix
~~~~
a) If the statistics of a table are not required to include in export
take the export with parameter STATISTICS=NONE

Example:
$exp scott/tiger file=emp1.dmp tables=emp STATISTICS=NONE
b) In case, the statistics are need to be included can use STATISTICS=ESTIMATE or
COMPUTE (default is Estimate).