Q

Dump file error

I've imported a file from cd to server and when I transfer the .dmp file to a user from another user, I get this error: "IMP-00009: abnormal end of export file." How can I settle this?

I've imported a file from cd to server and when I transfer the .dmp file to a user from another user, I get this error:

IMP-00009: abnormal end of export file
 
IMP-00028: partial import of previous table...terminated successfully 
with warning

How can I settle this?

The most common cause of this error is that the dump file was transferred to the database server using FTP and not explicitly stating to transfer in BINARY mode. To the FTP utility, the dump file can look like an ASCII file, when it is not. The solution is to perform the FTP operation again explicitly in BINARY mode.

If this does not fix your problem, then you will have to obtain another dump file; this dump file is corrupt.

This was first published in July 2005

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close