An error occurred while importing the oracle11g dmp file to oracle10g: Header Verification Failed --- Solution

An error occurred while importing the oracle11g dmp file to oracle10g: Header Verification Failed --- Solution

R & D personnel encountered the following problem:

Problem description:

The following error is reported when the dmp file exported from the 11g library is imported to the 10g Library:

Solution:

The cause of this problem is as described in the symptom, because the export occurs in the 11G environment, while the import occurs in the 10g environment. Oracle is backward compatible with the import and export of dmp files. That is to say, when the dmp files exported from the 10 Gb library can be directly imported to the 11 GB library, however, the dmp file exported from the 11g library must be modified so that oracle10g can be identified.

Solution:

Use the Notepad ++ tool to open the dmp file. The following version information is displayed at the beginning:

-- TEXPORT: V11.01.00

Check that the source database version is 10.2.0.1.0. Therefore, change the version information:

-- TEXPORT: V10.02.00

Import the dmp file again.

Follow-up questions:

Another R & D colleague's dial-up. When the file is too large, the memory will not be loaded if it is opened directly. How can I complete the import operation?

I checked it online. Someone wrote a c # small software to complete this task and solve the problem when the file is too large.

Download link:

Http://up.2cto.com/2012/0322/20120322023105139.rar

For more information, see the following link:

Http://www.bkjia.com/database/201203/124310.html