ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-31694

ORA-31694

原创 Linux操作系统 作者:dengxm 时间:2011-03-15 09:03:06 0 删除 编辑

给客户一个dmp,客户回复说导入报错。

$ impdp NEWTHSI/thsi directory=dump_dir dumpfile=20110226.dmp schemas=NEWTHSI

 
Import: Release 10.2.0.4.0 - 64bit Production on Friday, 04 March, 2011 11:05:26
Copyright (c) 2003, 2007, Oracle.  All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORA-39002: invalid operation
ORA-31694: master table "NEWTHSI"."SYS_IMPORT_SCHEMA_01" failed to load/unload
ORA-31640: unable to open dump file "/archive/arch1/20110226.dmp" for read
ORA-19505: failed to identify file "/archive/arch1/20110226.dmp"
ORA-27046: file size is not a multiple of logical block size
Additional information: 1
Additional information: -373203833
Additional information: 4096
 
想起之前遇到的问题,原因是expdp下载后使用了bin进行ftp get 而客户在用ftp put
的时候没有使用bin,导致文件破坏了。
 
 
解决办法:重新使用bin,进行put。统一使用了bin ,OK了
 
 
 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13726712/viewspace-689459/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-10-08

  • 博文量
    54
  • 访问量
    140765