在执行导出操作时,经常出现下面的错误。
. . 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/