Q

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.
This was first published in January 2007

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close