I get .dmp files every so often that I need to load in a database. Some of them are created with datapump and some with exp. Is there a simple way to tell them apart that I could put in a script?
Actual type of a .dmp file
550 views Asked by Jon Strayer At
2
There are 2 answers
0
On
Looks to me like the EXP format file contains the string EXPORT:V in the first "line". I don't see such a string in the data pump file. Use grep to tell the difference.
Another option is to attempt to load using IMP, check the return code, and if it fails (which you should know fairly quickly), try with IMPDP.
Get an example of each and look at them in a hex editor such as HxD. Each type probably has header or something else at the start of the file that identifies what it is. Open the file and check for which it is.