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就成功了
[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就成功了
- rman恢复好数据库 exp时 出错 EXP-00056 ORA-01403
- rman&exp
- exp,expdp导出数据库出错
- EXP-00056和 ORA-12154
- RMAN/EXP ORA-01455: 转换列溢出整数数据类型
- oracle 11g exp 报错 EXP-00056;ORA-12154;EXP-00000;
- 导出数据库时EXP-00008
- EXP
- exp
- EXP
- exp
- exp
- exp
- exp
- EXP
- exp时,ORA-00932: 数据类型不一致解决方法
- ORA-00904 & EXP-00091
- exp ORA-01455
- java条件表达式核心三点
- Zend Studio 实用快捷键一览表
- 纪念我在CSDN上留下了不朽的一贴~~700分的提问
- 怎么才能加分呢?在CSDN里
- 做了2年的程序,此时却没有了方向
- rman恢复好数据库 exp时 出错 EXP-00056 ORA-01403
- 2008.12.15
- js中一些常用的基本方法
- VC++内部COM插件的编程实现
- Wincor 400系列出钞故障代码
- 复制表结构
- ASP.NET编程中的十大技巧
- 信息系统审计
- Silverlight 2 RTW读取XPS解决方案