ITPub博客

首页 > Linux操作系统 > Linux操作系统 > EXP时 exp-00091错误的解决方法

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

原创 Linux操作系统 作者:phigon 时间:2019-06-12 18:27:06 0 删除 编辑

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

. . 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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: DDL 触发器 监控
请登录后发表评论 登录
全部评论

注册时间:2002-10-29

  • 博文量
    35
  • 访问量
    27411