Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

user12251389Aug 29 2016 — edited Dec 29 2016

I have export dmp file which are exported using 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 dmp par file has 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 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 export and import many times and it works for me previously. As we have different sever and database now and When i compared and open the previous export file,its showing the version `EXPORT:V11.02.00` where i am able to import but now for the new export its showing the verison `EXPORT:V12.01.00`. So it looks compatibility issue.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 26 2016
Added on Aug 29 2016
2 comments
2,673 views