Home » RDBMS Server » Server Utilities » Import error (Oracle10g,Linux)
Import error [message #287135] Tue, 11 December 2007 03:13 Go to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi,
I exported dumps from windows machine to linux machines.I export dunps the successfully but during the import i got the error
IMP-00009: abnormal end of export file
IMP-00028: partial import of previous table rolled back: 2255968 rows rolled back

I transfer the dumps from windows to linux machine using FTP use
binary modes.

my export command:

exp sava/simple@tiger file=exp.dmp log=exp_e.log statistics=none
compress=y

My import command:

imp system/simple@tiger file=exp.dmp log=exp.log fromuser=sava
touser=sava commit=y buffer=1000000000

how can i resolve this error?
Re: Import error [message #287141 is a reply to message #287135] Tue, 11 December 2007 03:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
dmp file may be corrupted or you didn't transfer in binary mode (although you think you did it) or you didn't use the correct version of the product.

Regards
Michel
Re: Import error [message #287196 is a reply to message #287135] Tue, 11 December 2007 06:39 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

When you reexport your database then add "consistent=y" in your export command.

consistent parameter
http://download.oracle.com/docs/cd/B14117_01/server.101/b10825/exp_imp.htm#sthref2337
Re: Import error [message #287237 is a reply to message #287135] Tue, 11 December 2007 09:24 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I exported dumps from windows machine to linux machines.
post Oracle versions to 4 decimal places for BOTH systems
Previous Topic: Message 2100 not found;
Next Topic: Only half the records from dat file is loaded into table using sqlldr
Goto Forum:
  


Current Time: Tue Dec 24 23:13:26 CST 2024