IMP-00010: not a valid export file tips

Question:  I exported all the tables in my database using exp export utility.  All the tables exported successfully. I specified exp file path correctly.  I tried to import the export file (called backupt.dmp) into other database using following import command:

imp scott/tiger@orcl1 file=c:\backupt.dmp formuser=exa touser=scott ignore=y

IMP-00010: not a valid export file, header failed verification
IMP-00000: Import terminated unsuccessfully

I specified exp file path correctly, yet I still get this IMP-00010 error.  What could have caused the export to be treated as invalid?

Answer:  The Oracle Oracle does note that the most common cause of the ORA-00010 invalid export file is a corrupted export file, but there are other cases that throw the ORA-00010 error message:

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

Cause: Either the file was not generated by Export or it was corrupted.

Action: If the file was indeed generated by Export, report this an Import bug and submit the export file to customer support.

If you did indeed use export (exp or expdp) to do the export, and you verified your path to the dmp file, the "IMP-00010: not a valid export file, header failed verification" error can be caused by these issues:

• Corruption from compression or FTP - If the export file was manipulated it may have become corrupted.  The most common cause with FTP is using an ASCII transfer and failing to use the binary flag:

ftp> binary
ftp> get -i myexportfile.zip

• Importing into an earlier version of Oracle - Dump files change formatting between releases, and it's impossible for any software to recognize a format that was not yet invented.  Trying a data pump export (expdp) as input to Oracle 8i will cause the "IMP-00010: not a valid export file, header failed verification" error message.

原始檔：http://www.dba-oracle.com/t_imp_00010_not_a_valid_export_file.htm 


祝好~

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/28602568/viewspace-759515/，如需轉載，請註明出處，否則將追究法律責任。