When I am trying to import a dump file into the remote machine, it is giving me the error "IMP-00009: abnormal end of export file." I tried to google it, but I just got that an answer for this problem is to retry the export and import because maybe the export file was created in the aborted export session. I did this but still got the same error. I generally do the export and import of a user, not the entire database. I created the tablespace with the same name at the remote end also and tried to import, but after importing a few tables it throws the above error. Can anyone help me out please?
The most common cause of this error is that the dump file was FTP'ed to another server and it was not explicitly stated to transfer in BINARY mode. The first few bytes of the dump file are ASCII characters and FTP utilities may autosense this file to be an ASCII file. Yet the file is truly a binary file. So whenever FTP'ing a dump file, explicitly state to transfer in binary mode:
(or use get depending on the server this was initiated from).
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.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.