若impdp导入失败,报错如下:
[oracle@linux ~]$ impdp userName/'password'@IP:PORT/Instance_ID directory=yourSetImportPathVariableName dumpfile=yourDmpFile.dmp logfile=yourLogName.log remap_schema=originalUserName:aimUserName
Import: Release 12.2.0.1.0 - Production on Wed Jun 12 16:52:34 2019
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
ORA-39002: invalid operation
ORA-31694: master table "aimUserName"."anyTableName" failed to load/unload
ORA-31644: unable to position to block number 179584 in dump file "yourDmpFile.dmp"
请检查你的dmp文件是否损坏,检查方法是查看将要导入的文件的MD5值是否与导出的文件的MD5值一致:
# Windows查看文件MD5
certutil -hashfile yourDmpFile.dmp md5
#Linux查看文件MD5
md5sum yourDmpFile.dmp