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."

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 userid=system@tns_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

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.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close