EXP-00091: Exporting questionable statistics 問題處理方法

tianya_2011發表於2015-07-27
Export
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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章