ORACLE - IMP-00010: not a valid export file

[Stephen Badgett]

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

[pat wickham]

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]

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.

[pat wickham]

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]

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

[Sanjay Kumar Suri]

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

[TwoProc]

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.

[Stephen Badgett]

Hi Pat,
I have tried this transfer in sftp in binanay and will try other methods listed in the thread
Steve

[Stephen Badgett]

Hi John

I am going to attempt this since this seem to be a logical choice.

[Stephen Badgett]

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)
)
)

[Raj D.]

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.

[Patti Johnson]

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]

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))
)

[TwoProc]

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.