|
|
IMP-00010: not a valid export file tips
Oracle Database Tips by Donald BurlesonJanuary 14, 2015
|
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:
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.
|
|
|
Get the Complete
Oracle Utility Information
The landmark book
"Advanced Oracle
Utilities The Definitive Reference" contains over 600 pages of
filled with valuable information on Oracle's secret utilities.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|
|
|
|