exp出错？用户的character和系统不同？

jzstorm

备份一个表，语句：
exp 名称/密码@sid file=lc_test.dmp tables=lc_test compress=n direct=y

出错：
Export: Release 8.1.5.0.0 - Production on Tue Sep 21 15:31:50 2004

(c) Copyright 1999 Oracle Corporation.  All rights reserved.


Connected to: Oracle8i Enterprise Edition Release 8.1.5.0.0, 64 bit - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
EXP-00041: Export done in server's ZHS16CGB231280, different from user's
                character set US7ASCII
EXP-00000: Export terminated unsuccessfully

怎么解决？

CNL

设置环境变量
NLS_LANG=AMERICAN_AMERICA.ZHS16CGB231280

jzstorm

我看oracle用户的环境变量如下，估计是不是被人改了？
# Set up the shell variables:
        EDITOR=vi
        export EDITOR
        ORACLE_BASE=/ora8i/app/oracle;export ORACLE_BASE
        ORACLE_HOME=$ORACLE_BASE/product/8.1.5;export ORACLE_HOME
        ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data;export ORA_NLS33
#       NLS_LANG=American_America.zhs16cgb231280;export NLS_LANG
        #NLS_LANG=American_America.zhs16cgb231280;export NLS_LANG
        SHLIB_PATH=$ORACLE_HOME/lib;export SHLIB_PATH
        PATH=$PATH:.ORACLE_HOME/bin:/bin:/bin/usr/bin:/usr/ccs/bin:/usr/local/
bin;export PATH
        DBCA_RAW_CONFIG=/home/oracle/object.asc;export DBCA_RAW_CONFIG
umask 022
TERM=hp;export TERM
ORACLE_SID=db97_1;export ORACLE_SID
DISPLAY=133.10.67.28:0.0;export DISPLAY

jzstorm

靠，不知道谁在NSL_LANG 前加个#，气死我了。