错误如下:
[oracle@mcprod admin]$ exp system/oracle file=/tmp/zhou.dmp owner=zhou
Export: Release 9.2.0.4.0 - Production on Sat Oct 10 07:18:10 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user ZHOU
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user ZHOU
About to export ZHOU'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
添加tempfile
SQL> select name from v$tempfile;
no rows selected
SQL> alter TABLESPACE TEMP add TEMPFILE '/Tbackup/dbtest/oradata/temp01.dbf' size 100m;
Tablespace altered.
导出成功
[oracle@mcprod admin]$ exp system/oracle file=/tmp/zhou.dmp owner=zhou
Export: Release 9.2.0.4.0 - Production on Sat Oct 10 07:34:49 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user ZHOU
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user ZHOU
About to export ZHOU's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export ZHOU's tables via Conventional Path ...
. . exporting table T 1 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.
[oracle@mcprod admin]$
分享到:
相关推荐
ORACLE9i exp遇见EXP-00008 ORA-00942 EXP-00024错误的解决方法,详细描述了问题处理的过程和步骤,共享在此,希望能有所帮助
oracle数据导出身份证明-用户名和口令-错误的解决方法
Oracle导dmp出现文件ORA-12154 TNS 无法解析指定的连接标识符解决方案
EXP-00056:ORACLE错误1033出现 ORA-01033:ORACLE initialization or shutdown in progress 用户: 口令: 这个显然是数据库没有办法启动,但是数据库服务还是可以启动,而程序则无法连接数据库。 首选找问题要看看...
在运行查询SELECT * FROM V$SESSION 会出现ORA-29275:部分多字节字符的错误,这是什么原因开始我不得其解,网上也没有介绍什么好办法。本文给出答案。
执行EXP导出时,部分表提示 EXP-00011:表不存在错误,但是查询user_all_tables视图,此表确实是存在的,并且执行select语句也能成功,不过表为空表,查看权限等也没有问题。后来通过查询资料,发现问题是由Deferred ...
NULL 博文链接:https://doing.iteye.com/blog/1677674
查看oracle出错信息,方便解决 EXP-00000导出终止失败 原因:导出时产生Oracle错误。
Oracle9i客户端带exp和imp命令,个人测试exp完美可以用,已经成功的导出了数据,没有出现错误,在xp下完美,对老系统非常好,使用时注意修改tnsnames.ora文件
配置增强型的Oracle简单客户端-Instant_Client 增加了exp、imp、tnsping、sqlplus、sqlloader等实用工具的配置
oracle11g基本客户端,主要是用于windows环境下sqlplus,sqlldr,exp,imp这几个命令。最最主要的还是sqlldr,想找个单独可用的sqlldr,在Oracle 10g Client 精简优化安装包不到12M ...
37. 如何在oracle7和oracle8之间exp-imp数据 38. 如何在Windows 2000下将Oracle完全卸载 39. 如何正确建立TYPE、partition(分区) 40. 如何正确利用Rownum来限制查询所返回的行数 41. 什么是ROWID,为什么需要...
oracle11g基本客户端,主要是sqlplus,sqlldr,exp,imp这几个命令。最最主要的还是sqlldr,想找个单独可用的sqlldr,在Oracle 10g Client 精简优化安装包不到12M ...
23 ORACLE客户端在P4上安装不成功 24由于LISTENER.ORA或TNSNAMES.ORA配置问题导致网络问题 25由于环境变量设置问题导致VERSOIN版本启动问题 26用户数据、表破坏下的数据恢复 27 由于OS层问题导致数据库ORA-600错误 ....
1、本软件可作为简单的Oracle10g客户端使用,包括:tnsping、exp、imp、sqlldr、sqlplus、tkprof(新增)等功能,如对客户端功能有更高的使用要求,请安装官方Oracle客户端。 2、本软件安装后,连接oracle服务器时...
1. Oracle逻辑错误造成无法启动 逻辑恢复: 重新create database及各tablespace,import。可恢复到上次export的数据 物理恢复: 将所有datafile copy回来,并利用archivelog将数据库recover到故障前的状态 2. 某一...
Oracle11G数据库的的exp和imp工具,数据库在做备份时若出现导出导入文件错误,一般是缺少exp.exe 和imp.exe工具或者该工具出行问题所致。使用方法:解压后将文件放到X:\development\Oracle\product\11.2.0\dbhome_1...