OraFAQ Forum: Server Utilities » Data Import Error

Home » RDBMS Server » Server Utilities » Data Import Error (oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Data Import Error [message #528641]

Wed, 26 October 2011 04:22

snsiddiqui
Messages: 172
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.

Report message to a moderator

Re: Data Import Error [message #528643 is a reply to message #528641]

Wed, 26 October 2011 04:26

Littlefoot
Messages: 21824
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?

Report message to a moderator

Re: Data Import Error [message #528669 is a reply to message #528643]

Wed, 26 October 2011 06:07

snsiddiqui
Messages: 172
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...

Report message to a moderator

Re: Data Import Error [message #528672 is a reply to message #528669]

Wed, 26 October 2011 06:21

Michel Cadot
Messages: 68758
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 13 14:31:32 CDT 2025