ORA-31694: master table "SYSTEM"."SYS_IMPORT_TABLE_01" failed to load/unload

impdp遇到如下报错

$ impdp  system/Oracle1234  cluster=N  directory=impdir dumpfile=exp_crc16_180926.dmp logfile=imp_crc16_180926.log  tables=user1.tab1  table_exists_action=replace

Import: Release 11.2.0.4.0 - Production on Wed Sep 26 16:41:21 2018

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-31694: master table "SYSTEM"."SYS_IMPORT_TABLE_01" failed to load/unload
ORA-31644: unable to position to block number 1005220 in dump file "/home/oracle/lzl/exp_crc16_180926.dmp"

 

对比源端和目标端dmp文件大小

-rw-r-----    1 oracle   asmadmin 4117573632 Sep 26 16:29 exp_crc16_180926.dmp
-rw-r--r--    1 oracle   oinstall       133750784 Sep 26 16:44 exp_crc16_180926.dmp

两边dmp文件大小不一致，在传输dmp文件过程中，dmp文件损坏了。

 

最后检查了home目录

/dev/hd1           0.12      0.00  100%       31    33% /home

/home没有空间了，找了个空闲目录来搞就可以了

 

tips：

ftp时需要敲 “bin”，以2进制传输，数据泵dmp文件都是二进制编码的，如果以ascii码传输会损坏文件（ftp默认以ascii传输）