IMP-00010 : Not a valid export file, header failed verification.
You do not have to precreate the tablespace, but it may be a good idea. If you do not have the tablespace(s) precreated, then the segments will be stored in the schema owner's default tablespace. If you have the dump file and want to see the tablespace where your tables and indexes will want to be created, run import with the INDEXFILE and FULL=Y options. This will create a text file which will show you the CREATE TABLE and CREATE INDEX statements. The tablespace will be shown there.
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.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.