General
cancel
Showing results for 
Search instead for 
Did you mean: 

ORACLE - IMP-00010: not a valid export file

Stephen Badgett
Regular Advisor

ORACLE - IMP-00010: not a valid export file

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

We exp using 10g version of Oracle and want to imp on a 9i. Is this possable? The error message "IMP-00010: not a valid export file, header failed verification" is what we have been getting when we tried. I have ftp'd the file using binary transfer more than once and we still get the same error.

Help is needed,

thank you,
Stephen
Not as is, is now
13 REPLIES
pat wickham
Occasional Visitor

Re: ORACLE - IMP-00010: not a valid export file

Hi

ORACLE - IMP-00010 due to file corruption. Was the export created from this client.

Your IMP-00010 error is most commonly caused when transferring the dump file with FTP and not explicitly stating to transfer in binary mode. Some FTP programs incorrectly see this file as a text file, which it is not. The dump file becomes corrupt on transfer. The only option is to retransfer in binary mode.


Regards,
Pat
Stephen Badgett
Regular Advisor

Re: ORACLE - IMP-00010: not a valid export file

I have tried to do this a few times using the "bi" option (binary) in ftp and same message. Does this mean that the FTP is actually corrupting the file? Is there something else?
I am using the 10g to do the exp and a 9i for the emp.
Not as is, is now
pat wickham
Occasional Visitor

Re: ORACLE - IMP-00010: not a valid export file

Hi Steve,
FTP should be done in binary mode. Maybe you have secure FTP or another utiliy which you can try to FTP this over with.
Yogeeraj_1
Honored Contributor

Re: ORACLE - IMP-00010: not a valid export file

hi stephen,

To move data DOWN a version(s), you need to export using that lower versions EXP tool and IMP using that lower versions tool.

To move data UP a version, you export using the EXP of the database that contains the data and you IMP using the imp that ships with the TARGET database.

You might find the sqlplus COPY command to be a nice tool as well as it avoids the intermediate files and just copies data about. It is pretty fast too.

How did you proceed? Can you post the exact steps?

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Sanjay Kumar Suri
Honored Contributor

Re: ORACLE - IMP-00010: not a valid export file

Using imp/exp accross different Oracle versions: If exp and imp are used to export data from an Oracle database with a different version than the database in which is imported, then the following rules apply:

1. exp must be of the lower version
2. imp must match the target version.

sks
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
TwoProc
Honored Contributor

Re: ORACLE - IMP-00010: not a valid export file

Stephen,

Go to your 9i machine and fix the tnsnames.ora file to talk to the 10g database. Connect to the 10g database from the 9i ORACLE_HOME when running exp to create a 9i export file. Then, import THIS file into 9i.
We are the people our parents warned us about --Jimmy Buffett
Stephen Badgett
Regular Advisor

Re: ORACLE - IMP-00010: not a valid export file

Hi Pat,
I have tried this transfer in sftp in binanay and will try other methods listed in the thread
Steve
Not as is, is now
Stephen Badgett
Regular Advisor

Re: ORACLE - IMP-00010: not a valid export file

Hi John

I am going to attempt this since this seem to be a logical choice.
Not as is, is now
Stephen Badgett
Regular Advisor

Re: ORACLE - IMP-00010: not a valid export file

how would I fix the tnsnames.ora to talk to the other machine?

is it something like this ?

DRX.ME.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = devload.me.com)(PORT = 1522))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = drx.me)
)
)
Not as is, is now
Raj D.
Honored Contributor

Re: ORACLE - IMP-00010: not a valid export file

IMP-00010 : It seems that version problem.

And make sure ftp'ed with binary version.

All seems due to version mismatch , export dump created on higher version can't be imported on lower version.

Cheers,
Raj.

" If u think u can , If u think u cannot , - You are always Right . "
Patti Johnson
Respected Contributor

Re: ORACLE - IMP-00010: not a valid export file

Stephen,

On the 9i server add another entry into your tnsnames.ora file that refers back to the 10g database. This is the same entry that you would put on any client machine to communicate with the 10g database.

If you are unsure of the correct values for port, service_name, etc you can use the tnsping command from the 10g server to get the correct values. Then just add an entry similar to the one you listed with the new values.

Test the connection from the 9i server using sqlplus.
sqlplus user/passwd@10g_connect_string

Once that works you can run the export command on the 9i server and create the dump file locally.

exp user/passwd@10g_connect_string.

You will have problems if you are using any new 10g features that are not supported on 9i.

Patti


TwoProc
Honored Contributor

Re: ORACLE - IMP-00010: not a valid export file

Re: tnsnames.ora addition:

Let's say the 10G machine is "srva" and the port is 1522, and the ORACLE_SID on THAT machine is MYDB.

We'll name the connection "MYDB" by adding this to the tnsnames.ora file:

MYDB = (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=srva)(PORT=1522))
(CONNECT_DATA=(SID=MYDB))
)

We are the people our parents warned us about --Jimmy Buffett
TwoProc
Honored Contributor

Re: ORACLE - IMP-00010: not a valid export file

The above entry's formatting got pretty toasted by the itrc server, but it's not that important, you can put all the above on the same line.
We are the people our parents warned us about --Jimmy Buffett