oracle导出报EXP-00091: Exporting questionable statistics.

32饿1e

用exp导出数据时出现如下报错信息：


1）查询数据库的字符集
select userenv('language') from dual;


2）设置Linux操作系统的NLS_LANG环境变量
[oracle@node1]$ $export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
或是修改oracle用户下环境变量.bash_profile文件

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

# .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 TMP=/tmp;export TMP TMPDIR=$TMP;export TMPDIR ORACLE_BASE=/opt/oracle;export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1;export ORACLE_HOME ORACLE_SID=report;export ORACLE_SID LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH PATH=$ORACLE_HOME/bin:$PATH; export PATH LANG=en_US.utf8; export LANG NLS_LANG=AMERICAN_AMERICA.ZHS16GBK; export NLS_LANG

Window系统的环境变量的修改方法是：
C:\>set NLS_LANG=AMERICAN_AMERICA.ZHS16GBK