Backup _ imp import error due to inconsistent client and database versions

Backup _ imp import error due to inconsistent client and database versions

Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for copyright.

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

 

Today, I tested some data for my R & D team members, but I encountered a problem during R & D import, as shown below:

At first glance, this error occurs, and the exported dmp file is checked as follows:

R & D said his version is also 11.2, and it is determined that it is not a database version problem.

So I checked what he sent later and found the problem as follows:

The figure shows that the R & D import operation occurs on the 10 Gb client. Although the database is 11 GB, oracle is backward compatible, A 10g client cannot import 11g dmp files. Modify the file version in dmp as follows:

 

Summary:

We should pay attention to the database version and Client Version when importing and exporting dmp.

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

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

 

Small knowledge, easy to remember.

 

Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for copyright.

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