Q
Problem solve Get help with specific problems with your technologies, process and projects.

IMP-00009 and IMP-00028 errors during import

I'm trying to import a dump file and I have the errors "IMP-00009: abnormal end of export file" and "IMP-00028."

Brian Peasland
By
Published: 22 Mar 2007
I'm trying to import a dump file and I have the errors "IMP-00009: abnormal end of export file" and "IMP-00028." The export file was made on Oracle 9.2.0.8, and I tried to import on Oracle 9.2.0.4. Is this error due to bad transfer or is it due to the Oracle version?
When transferring data between two different versions, follow these steps:
  1. Use the lower version of exp to create the dump file. You can connect to a remote database with the exp utility by using a TNS alias when specifying the username: 
    exp [email protected]_alias full=y .....
  2. Use the destination database's imp version.
But your versions are the same major versions and only different in patchset levels. And looking at your error message, I am guessing that the dump file was FTP'ed wrong. When you FTP the dump file, explicitly state 'bin' so as to transfer in binary mode. Some FTP utilities incorrectly sense the dump file to be an ASCII file and the transfer corrupts the dump file.

Dig Deeper on Oracle database backup and recovery

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close