Re: oracle 9.2.0.1 import problem

From: Norman Dunbar <Norman_at_Dunbar-it.co.uk.REMOVETHIS>
Date: Tue, 01 Feb 2005 12:06:01 +0100
Message-ID: <ctnr3f$39e$1$8302bc10@news.demon.co.uk>

nagarajan kesavan via OracleMonster.com wrote:
> hi guys, i need ur help. i am having oracle 9.2.0.1 in RH ES 2.1 in 2 different machines. i just want to export data from one machine to another machine. but the import terminates abnormally with error IMP-00009: Abnormal end of export file. i dont know what to do? please help
> its urgent..
> i tried many times exporting and importing, but it failed with same problem
>

Morning,

(your line length is a bit wide !!)

a couple of things to check out :

Did you FTP the file in binary mode to the other server? If not, that could be the reason as export files are binary not text.

Is the filesize on one server that same as on the other? If not, there's your problem.

What happens when you run the import with SHOW=YES to simply list the contents of the dump file? Does it list everything you expect or not? If not, you do indeed have a truncated dump file.

Did the export complete without warnings? Check the logfile to make sure.

HTH Cheers,
Norm. Received on Tue Feb 01 2005 - 05:06:01 CST