I have export DMP files which are exported using the exp command from oracle version 11.2.0.4.0. I want to import the file in my oracle version 11.2.0.2.0. But during import I am getting an error as 'IMP-00010 not a valid export file, header failed verification'
.
The export dump par file has the following information :
USERID=TEST_CONFIG/TEST_CONFIG@Ik567G
OWNER=TEST_CONFIG
LOG=test01.log
FILE=test01.dmp
INDEXES=Y
CONSTRAINTS=Y
GRANTS=Y
COMPRESS=Y
FULL=N
ROWS=Y
CONSISTENT=Y
BUFFER=80200
FEEDBACK=500
And the import DMP test_config par file has the following information :
LOG=TEST_CONFIG.log
FILE=test01.dmp
FROM USER=TEST_CONFIG
FULL=n
ROWS=n
INDEXES=n
CONSTRAINTS=y
IGNORE=y
I am running the import using following command :
imp TEST_CONFIG/TEST_CONFIG PARFILE=test_config.par
imp TEST_CONFIG/TEST_CONFIG PARFILE=test_config.par
I tried to export and import many times and it works for me previously. As we have a different servers and databases now and When I compared and open the previous export file, it's showing the version EXPORT:V11.02.00
where I am able to import but now for the new export it's showing the version EXPORT:V12.01.00
. So it looks compatibility issue.
IMP-00010: not a valid export file, header failed verification. This would give you the impression that something is wrong with the file you are trying to import. I got the same error but it was just STUPID Oracle being stupid. There was nothing wrong with my file. imp user/password@server/service FILE=mydumpfile.dmp The above command gave the error from my client PC but worked perfectly if I ran it from the server using a remote desktop connection.