exp报错。。。。。。。

zly0216

bdwjf1>;  NLS_LANG=AMERICAN.ZHS16CGB231280
bdwjf1>; export NLS_LANG
bdwjf1>; exp sys/test@ywyt1  full=y file=ywytall.dmp log=ywytall.log

Export: Release 8.1.7.4.0 - Production on Thu Jun 23 15:38:01 2005

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


Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning and Parallel Server options
JServer Release 8.1.7.4.0 - Production
Export done in ZHS16CGB231280 character set and ZHS16CGB231280 NCHAR character set

About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
EXP-00008: ORACLE error 904 encountered
ORA-00904: invalid column name
EXP-00000: Export terminated unsuccessfully

数据库字符集为：
select * from V$NLS_PARAMETERS;
NLS_LANGUAGE                   AMERICAN
NLS_CHARACTERSET               ZHS16CGB231280

我环境设置为：
bdwjf1>;  NLS_LANG=AMERICAN.ZHS16CGB231280
bdwjf1>; export NLS_LANG

为什么？？？？？？

yingqing13

把備份文件的路徑寫完整試試

弱智

怎么会有不识别的列名？

remen

DB版本？平台？EXP/IMP工具版本？

remen

DB版本？平台？EXP/IMP工具版本？

txfy

try to run this sql


rdbms\admin目录下的CATEXP.SQL

zly0216

谢谢txfy！！

执行一下catexp.sql就可以了。。。。      
是什么原因造成的？