Category Archives: Uncategorized

Common reasons for IMP-00010 during import

If you try to import a file and you get the following error:

IMP-00010: not a valid export file, header failed verification
IMP-00000: Import terminated unsuccessfully

The cause according to Oracle error description is “Either the file was not generated by Export or it was corrupted”. The first obvious reason might be that the file is corrupted. However, if you downloaded it correctly (using binary transfer in the FTP as opposed to ASCII transfer) and you have no other reason to believe that the file is indeed corrupted. You might want to explore other options.
The most common reason for this error is mismatch of IMP and EXP versions. While it should not be a problem to import a file that was created with an earlier version of EXP using a newer version of IMP, trying to use it the other way will generate the above error. In other words, you can import a file that was created with 10g version of EXP using a 9i version of IMP. If this is the case, try to export the file using a lower version of EXP or try to import the file to a higher version Database. Later you can export it again using a lower version of the EXP utility.
Another reason, over looked many times, is that the file was exported using Data Pump (EXPDP not EXP)  . If you are not the one who exported the file, try to restore it using the Data Pump import utility IMPDP. Since Data Pump is gaining traction and it is creating .dmp files it is possible that the dmp file in your hands was created using it.

Nothing to see (Yet)

The purpose of DB tricks is to serve as an online repository of Data Base  tips I encounter during my work. Sometimes, it can be very frustrating to search (again) for a solution for a problem you already solved.  No matter how important it may look now, chances are you will not remember anything about it when it will happen again after few months. This is the rational behind DB Tricks. In a way, it will be a place where I could store and share solutions and save myself (and maybe you) some research time in the future.

So, in the following days many things are going to change here.  As they say in techcrunch, ” we are in private alpha”. Fisrt post is coming soon.