rman恢复好数据库 exp时 出错 EXP-00056 ORA-01403

来源:互联网 发布:macbook安装软件找不到 编辑:程序博客网 时间:2024/06/16 22:39
在前一章中 数据库恢复好后 进行exp时 报错如下
[oracle@testsmb admin]$ exp SJTICKET/fortest@SJTICKET rows=y indexes=y CONSTRAINTS=Y compress=n buffer=4096 feedback=100000 file=/opt/oracle/mxj_test.dmp log=/opt/oracle/mxj_test.log

Export: Release 9.2.0.4.0 - Production on Mon Dec 15 16:13:38 2008

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 ZHS16GBK character set and AL16UTF16 NCHAR character set
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user SJTICKET
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user SJTICKET
About to export SJTICKET's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 1403 encountered
ORA-01403: no data found
EXP-00000: Export terminated unsuccessfully

经过查询错误发现是由于 临时表空间的问题
create temporary TABLESPACE TEMP1 TEMPFILE '/opt/oracle/oradata/SJTICKET/temp01.dbf' size 100m;

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP1;

在 exp就成功了