EXP时 exp-00091错误的解决方法-CSDN博客

在执行导出操作时，经常出现下面的错误。

. . exporting table REPCAT$_USER_AUTHORIZATIONS
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.

分析问题

[orarac@db1 ~]$ oerr exp 91
00091, 00000, "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.
[orarac@db1 ~]$

解决问题：

第一步，查询数据库中的字符集参数的值

SQL> col parameter format a40
SQL> col value format a60
SQL> set linesize 200
SQL> select * from v$nls_parameters;
PARAMETER VALUE
---------------------------------------- ------------------------------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_CHARACTERSET AL32UTF8
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM

PARAMETER VALUE
---------------------------------------- ------------------------------------------------------------
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE

19 rows selected.

注意：字符集设置。

第二步，设置环境变量NLS_LANG

在执行导出操作的计算机上设置环境变量

在UNIX /Linux系统中
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
echo $NLS_LANG

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

转载于:http://blog.itpub.net/26764/viewspace-509492/