ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle之EXP-00091

oracle之EXP-00091

原创 Linux操作系统 作者:liqilin0429 时间:2012-05-17 15:20:18 0 删除 编辑
EXP-00091: Exporting questionable statistics.解决方案
第一 出现的问题:
[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
第二 在所在的OS上设置NLS_LANG环境变量为数据库的数据集
A 查询数据库的字符集
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.ZHS16GBK
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
SIMPLIFIED CHINESE_CHINA.ZHS16GBK
B 设置Linux操作系统的NLS_LANG环境变量到ORACLE 用户的.bash_profile文件中
# .bash_profile
# Get the aliases and functions
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
第三 推出当前导出数据的用户,再次进入就可以了     

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

上一篇: oracle之DBLINK
下一篇: oracle之ORA-03113
请登录后发表评论 登录
全部评论

注册时间:2010-08-13

  • 博文量
    100
  • 访问量
    194873