oracle11g dmp file Import oracle10g when error: Header validation failed---resolved

Original works, from the "Blue Blog" blog. Welcome reprint, please be sure to indicate the source when reproduced. Otherwise be held responsible for copyright law.

Deep Blue Blog:http://blog.csdn.net/huangyanlong/article/details/40152785

Today's developers are encountering problems with dmp files that cannot be imported:

Description of the problem:

The dmp file exported by the 11g Library. Import into a library in 10g times such as the following error:

Solution Ideas:

The solution to this problem is the same as the description of the phenomenon. Because the export occurs in a 11g environment, the import occurs in a 10g environment. For the import, export of dmp files. Oracle is backwards compatible, meaning that dmp files exported by the 10g Library are directly imported into the 11g Library, but 11g The library export of dmp files, is required to make version number changes so that oracle10g can recognize talent enough.

Solution:

Use the notepad++ tool to open the dmp file. The version number information, such as the following, is seen first:

--texport:v11.01.00

View the source-side database version number is 10.2.0.1.0, so change the version number information to:

--texport:v10.02.00

Run the import again successfully to import the dmp file.

Perhaps the problem:

The research and development of a colleague's coaching. When the file is too large. If you open it directly, the memory will not be loaded in. How to finish the import operation?

In the online search, originally someone wrote a C # Small software can also complete this task, and conquer when the file is too large problem.

Download Link:

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

Can participate in other users of the article. Links such as the following:

Http://www.2cto.com/database/201203/124310.html

Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the source, otherwise hold the copyright legal responsibility.

Deep Blue Blog:http://blog.csdn.net/huangyanlong/article/details/40152785

Copyright notice: This article Bo Master original articles, blogs, without consent may not be reproduced.

oracle11g dmp file Import oracle10g when error: Header validation failed---resolved