EXP-00091: Exporting questionable statistics

最新推荐文章于 2024-04-24 21:00:00 发布

转载最新推荐文章于 2024-04-24 21:00:00 发布 · 56 阅读

本文介绍了当遇到Oracle导出过程中出现疑问统计数据的问题时的解决办法。问题出现的原因包括导出过程中发生行错误、客户端字符集与服务器不匹配等。解决方法涉及调整客户端字符集以匹配服务器设置。

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 desired, import parameters can be supplied so that only non-questionable statistics will be imported, and all questionable statistics will be recalculated.

EXP-00091: Exporting questionable statistics.
. . exporting table                     MV_SERVICE       1022 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table                  MV_SERVICEFEE        691 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                     PLAN_TABLE          0 rows exported
. . exporting table             TAB_BROWSERCATALOG    1407427 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                 TAB_BROWSERFEE      59233 rows exported……………………………

解决方法：

select * from nls_database_parameters t where t.parameter=’NLS_CHARACTERSET’

or
select * from v$nls_parameters where parameter=’NLS_CHARACTERSET’;
查询值为：ZHS16CGB231280

然后vi /home/oracle/.bash_profile

export NLS_LANG=american_america.ZHS16CGB231280

source /home/oracle/.bash_profile

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-629060/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-629060/