Hi, in this article we are going to learn how to check datapump dump file is corrupted or not. Actually, sometimes we face the situation we take the export backup a long time back and we are not sure the dump file is still valid or not. Sometimes the application team saying the dump file is corrupted which provided by you.
Check Datapump dump file is corrupted or not
So here is the easiest way to check the dumpfile is corrupted or not. Using the below command we can verify the dump file.
How to import DDL only
$impdp directory=dir dumpfile=scott.dmp logfile=imp_scott.log sqlfile=to_check_corruption_ddl.sql
In the above example we used the sqlfile parameter which is never be going to import any data it is just written DDL statements in the file which we mention in the command (to_check_corruption_ddl.sql). So it’ll read the entire dumpfile and will report if any corruption is deducted.
Connect with me on: