oracle之EXP-00091
EXP-00091: Exporting questionable statistics.解決方案
第一 出現的問題:
[oracle@standby ~]$ exp lcpt/lcpt file=/home/oracle/lcpt_1.dmp wner=lcpt
第一 出現的問題:
[oracle@standby ~]$ exp lcpt/lcpt file=/home/oracle/lcpt_1.dmp wner=lcpt
Export: Release 11.2.0.1.0 - Production on Thu May 17 14:50:42 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.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)
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user LCPT
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user LCPT
About to export LCPT's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export LCPT's tables via Conventional Path ...
. . exporting table ACCESSORIES 6 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table AUTH 226 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table DATA_TEMP 5 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table FUNCTION 107 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table LIMIT 1 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table MODULE 33 rows exported
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user LCPT
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user LCPT
About to export LCPT's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export LCPT's tables via Conventional Path ...
. . exporting table ACCESSORIES 6 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table AUTH 226 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table DATA_TEMP 5 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table FUNCTION 107 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table LIMIT 1 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table MODULE 33 rows exported
第二 在所在的OS上設定NLS_LANG環境變數為資料庫的資料集
A 查詢資料庫的字符集
SQL> select userenv('language') from dual;
A 查詢資料庫的字符集
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.ZHS16GBK
----------------------------------------------------
AMERICAN_AMERICA.ZHS16GBK
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
SIMPLIFIED CHINESE_CHINA.ZHS16GBK
----------------------------------------------------
SIMPLIFIED CHINESE_CHINA.ZHS16GBK
B 設定Linux作業系統的NLS_LANG環境變數到ORACLE 使用者的.bash_profile檔案中
# .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
#PATH=$PATH:$HOME/bin
#export PATH
export ORACLE_BASE=/u01/oracle
export ORACLE_HOME=$ORACLE_BASE/product/OraHome
export ORACLE_SID=standby
export ORACLE_OWNER=oracle
export ORACLE_TERM=vt100
export PATH=$PATH:$ORACLE_HOME/bin:$HOME/bin
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
~
".bash_profile" 20L, 423C written
C 或則直接設定
[oracle@standby ~]$ export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
C:\Users\QiLin>set NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK
export ORACLE_HOME=$ORACLE_BASE/product/OraHome
export ORACLE_SID=standby
export ORACLE_OWNER=oracle
export ORACLE_TERM=vt100
export PATH=$PATH:$ORACLE_HOME/bin:$HOME/bin
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
~
".bash_profile" 20L, 423C written
C 或則直接設定
[oracle@standby ~]$ export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
C:\Users\QiLin>set NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK
第三 推出當前匯出資料的使用者,再次進入就可以了
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/20976446/viewspace-730026/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- EXP-00091解決辦法
- EXP-00091: Exporting questionable statisticsExport
- EXP-00091錯誤解決
- EXP-00091 Exporting questionable statisticsExport
- EXP-00091解決方法(轉)
- 解決EXP-00091的方法
- EXP-00091: Exporting questionable statistics.Export
- EXP-00091問題的解決
- EXP-00091 Exporting questionable statistics錯誤Export
- EXP--解決EXP-00091的方法
- Exp匯出報錯EXP-00091分析解決
- EXP-00091: Exporting questionable statistics 處理辦法Export
- EXP--解決EXP-00091的方法 (轉貼)
- EXP-00091: Exporting questionable statistics 問題處理方法Export
- 轉帖:EXP-00091: Exporting questionable statistics.解決方法Export
- EXP-00091: Exporting questionable statistics.錯誤解決方案Export
- Windows環境下EXP-00091錯誤的解決辦法Windows
- EXP error EXP-00003 EXP-00091 EXP-00015Error
- Oracle之StatspackOracle
- Oracle 之HWMOracle
- oracle之StatisticsOracle
- oracle之errorsOracleError
- oracle 之errorsOracleError
- oracle之spoolOracle
- oracle之序列Oracle
- Oracle之表Oracle
- oracle之 Oracle LOB 詳解Oracle
- 【故障處理】EXP-00091: Exporting questionable statistics 問題處理方法Export
- oracle之 RAC Interconnect之HAIPOracleAI
- oracle之nalyze tableOracle
- oracle之hint概述Oracle
- Oracle之Sequence(序列)Oracle
- oracle之dblinksOracle
- oracle之BUG 7497640Oracle
- oracle之DBLINKOracle
- Oracle之記錄Oracle
- Oracle之結構Oracle
- oracle之 Oracle歸檔日誌管理Oracle