Problem solve Get help with specific problems with your technologies, process and projects.

Import of .dmp file from 64-bit to 32-bit machine

I am trying to import an Oracle .dmp file generated on a 64-bit machine onto a 32-bit machine, but I am getting an import error. How can I perform the import?

I am trying to import a .dmp file generated on a 64-bit machine (Oracle Server version 8.1.0) onto a 32-bit machine (Oracle Server version 8.1.0), but I am getting an error as below:

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

This dump has been received via HTTP file transfer (i have got it uploaded twice and there is no corruption in the .dmp file received).

Is it possible to do it? If yes, can you tell me how can I import this dump onto the 32-bit machine?

The problem with HTTP file transfer for this activity is that it assumes the file is an ASCII file. The dump file is a BINARY file. As such, you must make sure that you transfer the file in BINARY mode. FTP programs that autosense the file type often corrupt the Oracle export dump in this manner by assuming the file is an ASCII file. Retransfer your file, this time in BINARY mode, and I bet you won't have this problem.

Dig Deeper on Oracle database backup and recovery