oracle exp命令求助

soccer

exp system/password file=/home/oracle/test.dmp full=y

下面是日志，请问为什么会报错，导出失败。我觉得是不是因为数据库字符集和客户端字符集不符的问题？  谢谢

Export: Release 9.2.0.4.0 - Production on Wed Apr 26 13:20:57 2006

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Export done in ZHS32GB18030 character set and AL16UTF16 NCHAR character set

About to export the entire database ...
. exporting tablespace definitions
EXP-00068: tablespace T001 is offline
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
EXP-00008: ORACLE error 6552 encountered
ORA-06552: PL/SQL: Compilation unit analysis terminated
ORA-06553: PLS-553: character set name is not recognized
EXP-00000: Export terminated unsuccessfully

[ 本帖最后由 soccer 于 2006-5-8 17:04 编辑 ]

caribe

每次都会报错，还是偶然碰到的？

soccer

原帖由 caribe 于 2006-4-27 09:39 发表
每次都会报错，还是偶然碰到的？

每次都这样，我觉得应该是字符集的问题，因为props$里字符被改过，另一台服务器用同样的方法导出数据就没问题。

谢谢

skytears

先alter tablespace T001 online;
然后再exp

soccer

原帖由 skytears 于 2006-4-27 13:37 发表
先alter tablespace T001 online;
然后再exp

T001是系统表空间吗？

alter tablespace T001 online; 出现下面的日志，

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
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
EXP-00008: ORACLE error 6552 encountered
ORA-06552: PL/SQL: Compilation unit analysis terminated
ORA-06553: PLS-553: character set name is not recognized
EXP-00000: Export terminated unsuccessfully

谢谢

adwater

那该是字符集的问题
看你报错的机器的字符集是什么?
跟ORACLE的有什么差别

shugen1712

顶，

soccer

数据库字符集是：AMERICAN_AMERICA.ZHS32GB18030

报错机器的字符集是指 系统的字符集吗？

echo $LANG  是这个？


Export done in ZHS32GB18030 character set and AL16UTF16 NCHAR character set

这句话是什么意思？ AL16UTF16 NCHAR是指客户端吗？


谢谢

[ 本帖最后由 soccer 于 2006-5-8 17:09 编辑 ]