Problems with the Oracle import

Question

Problems with the Oracle import

Navigation

#1 by (1 votes)

1

I have a query, I have a dmp (dump) file from oracle 12c , and I need to import it into 11c , but for some reason, I am not able to correctly perform my import .

I am running:

impdp usuario/password schema=nombreDelEsquema VERSION=11 DIRECTORY=dirdmp DUMPFILE=NombreDelArchivo.DMP

... where dirdmp is a directory that I created, indicating the path where the dump file I want to import is located.

Running the command generates the following error:

ORA-39142: incompatible version number 4.1 with the dump file

How to solve this problem?

oracle

asked by Gustavo 04.11.2016 в 19:30

source

1 answer

Change the Setting of the Preview How to make the view that I am loading in the controller run

score 1 · Accepted Answer

Normally, you should not export / import from a newer version to an older version. The problem is that the export of the newer version may include objects that do not even exist in the older version.

I get the impression that you are already aware of this problem, and probably that is why you tried to add the version parameter during the import.

However, it is not during the import that you need to specify the version parameter. Rather, you should use the version parameter during export ( expdb ) so that the dmp file does not include artifacts specific to version 12c.

Therefore, start by re-executing the export using the VERSION=11 parameter as you have it. And then you can try the import again.