ITPub博客

首页 > Linux操作系统 > Linux操作系统 > EXP-00091: Exporting questionable statistics 问题处理方法

EXP-00091: Exporting questionable statistics 问题处理方法

原创 Linux操作系统 作者:tianya_2011 时间:2015-07-27 09:14:35 0 删除 编辑
1,环境:
操作系统:HP-UX SCUP15 B.11.31
数据库:oracle 10.2.0.5


2,问题说明:
在我们对Oracle做EXP的过程中,可能会经常遇到EXP-00091 Exporting questionable statistics.的信息,其实它就是exp的error message,它产生的原因是因为我们exp工具所在的环境变量是的NLS LANG中的NLS_CHARCATERSET不一致引起的。但需要说明的是,EXP-00091这个error对所生成的dump文件没有影响,生成的dump文件还可以正常imp。

$ exp  test/test  file=/ora1/orabak/test.dmp owner='test' log=/ora1/orabak/test.log

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user test 
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user test 
About to export test's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export test's tables via Conventional Path ...
. . exporting table                         TEST_1         46 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                       TEST_BAK         23 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                            SAP         29 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
......
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully with warnings.


3, 处理方法:
指定hp-ux系统的NLS_LANG环境变量为数据库的数据集

 1)查询数据库的字符集(方法很多只用一种)
  SQL> select userenv('language') from dual;
 USERENV('LANGUAGE')
 ----------------------------------------------------
 SIMPLIFIED CHINESE_CHINA.ZHS16GBK

2)设置hp-ux操作系统的NLS_LANG环境变量
 $ export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"


4,处理完成,再进行exp就不会报这个错误了。
Export terminated successfully without warnings.

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

请登录后发表评论 登录
全部评论

注册时间:2011-04-11

  • 博文量
    85
  • 访问量
    606871