Home » RDBMS Server » Server Utilities » Data Import Error (oracle 9i)
Data Import Error [message #528641] Wed, 26 October 2011 04:22 Go to next message
snsiddiqui
Messages: 168
Registered: December 2008
Senior Member
I am importing oracle 9i export into oracle 9i but after importing some tables I am facing error so would anyone guide me, what should I do?

IMP-00009: abnormal end of export file
IMP-00018: partial import of previous table completed: number rows imported

this table contains 12713206 records.
Re: Data Import Error [message #528643 is a reply to message #528641] Wed, 26 October 2011 04:26 Go to previous messageGo to next message
Littlefoot
Messages: 21530
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It seems that the export file is corrupted and not all data was imported properly.

So, was the export done successfully (without errors)? Can you check that in export's log file? What does its summary line(s) say? If it is OK, how did you get that export file? Could you acquire it once again and re-import?
Re: Data Import Error [message #528669 is a reply to message #528643] Wed, 26 October 2011 06:07 Go to previous messageGo to next message
snsiddiqui
Messages: 168
Registered: December 2008
Senior Member
There is no error in log file and I have tried multiple times but the error is same.

any other idea...
Re: Data Import Error [message #528672 is a reply to message #528669] Wed, 26 October 2011 06:21 Go to previous message
Michel Cadot
Messages: 66851
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As LittleFoot said: "It seems that the export file is corrupted".
Did you transfer the file in binary mode?
Did you export into one or multiple files?

Regards
Michel
Previous Topic: tool to create CTL file?
Next Topic: sqlldr loading into a clob col
Goto Forum:
  


Current Time: Wed Feb 19 14:05:22 CST 2020