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博客

EXP-00091: Exporting questionable statistics

最新文章