I brought a dump file from a client (from user login, not from system user), and now I want import it. I do not know the tablespace name. Is it necessary to create the tablespace and data file as it was created from where I have exported? If not, then how do I proceed? I am getting an error message as below:
IMP-00010 : Not a valid export file, header failed verification.

    Requires Free Membership to View

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.

This was first published in May 2005

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: