woto123 2015-07-26 06:55 采纳率: 0%
浏览 7037

oracle使用imp导入数据库出问题IMP-00009

** imp导入数据库中途出错**:(:IMP-00009、IMP-00027、IMP-00003、ORA-01013:);dmp文件大小500G

emp导出日志(部分)
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user SHDUCHA
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user SHDUCHA
About to export SHDUCHA's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export SHDUCHA's tables via Conventional Path ...

imp导出日志(部分)
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export file created by EXPORT:V10.02.01 via conventional path
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
.
.
. . importing table "TB_I_G_3_106_82_97" 72632 rows imported
. . importing table "TB_I_G_3_106_83_101"
IMP-00009: abnormal end of export file
IMP-00027: failed to rollback partial import of previous table
IMP-00003: ORACLE error 1013 encountered
ORA-01013: user requested cancel of current operation
IMP-00000: Import terminated unsuccessfully

  • 写回答

3条回答 默认 最新

  • threenewbee 2015-07-26 07:01
    关注
    评论

报告相同问题?

悬赏问题

  • ¥20 求数据集和代码#有偿答复
  • ¥15 关于下拉菜单选项关联的问题
  • ¥20 java-OJ-健康体检
  • ¥15 rs485的上拉下拉,不会对a-b<-200mv有影响吗,就是接受时,对判断逻辑0有影响吗
  • ¥15 使用phpstudy在云服务器上搭建个人网站
  • ¥15 应该如何判断含间隙的曲柄摇杆机构,轴与轴承是否发生了碰撞?
  • ¥15 vue3+express部署到nginx
  • ¥20 搭建pt1000三线制高精度测温电路
  • ¥15 使用Jdk8自带的算法,和Jdk11自带的加密结果会一样吗,不一样的话有什么解决方案,Jdk不能升级的情况
  • ¥15 画两个图 python或R