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
    关注
    评论

报告相同问题?

悬赏问题

  • ¥50 汇编语言除法溢出问题
  • ¥50 C++实现删除N个数据列表共有的元素
  • ¥15 Visual Studio问题
  • ¥15 state显示变量是字符串形式,但是仍然红色,无法引用,并显示类型不匹配
  • ¥20 求一个html代码,有偿
  • ¥100 关于使用MATLAB中copularnd函数的问题
  • ¥20 在虚拟机的pycharm上
  • ¥15 jupyterthemes 设置完毕后没有效果
  • ¥15 matlab图像高斯低通滤波
  • ¥15 针对曲面部件的制孔路径规划,大家有什么思路吗