Backup _ Imp Import error due to a non-uniform client and database version

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

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

Today, research and development buddies to guide some data to do test, but research and development in the import encountered a problem, as follows:

At first glance at this error, think of the wrong version, so check the exported dmp file, as follows:

Research and Development says his version is also 11.2, judging not the database version issue.

Then look at the follow-up he sent, found the problem, as follows:

From the figure, the development of the import operation is occurring on the 10g client, although the database is 11g , but Oracle is backward compatible, with 10g client is unable to complete the 11g the dmp file is imported. Therefore, modify the file version of DMP as follows:

Summary:

We should be aware of the version of the database and the version of the client in the DMP Import and export.

If the dmp file is too large, it is not easy to modify the version, you can refer to the following:

http://blog.csdn.net/huangyanlong/article/details/40152785

Small knowledge, simple and remember.

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

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

Backup _ Imp Import error due to a non-uniform client and database version