oracle-databaseoracle-dumporacle-export-dump

IMP-00010 not a valid export file, header failed verification in Oracle Import


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.


Solution

  • 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.