给客户一个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
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/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/13726712/viewspace-689459/
1709
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
