Check Datapump dump file is corrupted or not

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.

Read – How to use REMAP_TABLE parameter in impdp utility

Connect with me on:

Instagram: https://www.instagram.com/shripaldba
Linkedin: 
https://www.linkedin.com/in/shripal-singh
Twitter: 
https://twitter.com/ocptechnology
Facebook: 
https://www.facebook.com/ocptechnology
YouTube:
https://www.youtube.com/ocptechnology

1 thought on “Check Datapump dump file is corrupted or not”

Leave a Comment

%d bloggers like this:
Enable Notifications    OK No thanks