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