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
Karma: 0
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: 65153
Registered: March 2007
Location: Nanterre, France, http://...
Karma: 0
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
Karma: 0
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: 25578
Registered: January 2009
Location: SoCal
Karma: 0
Senior Member
>I exported dumps from windows machine to linux machines.
post Oracle versions to 4 decimal places for BOTH systems
Previous Topic: import/export query
Next Topic: HOW CAN I RECOVER DATA IN ORACLE DATABASE 8.1.5 WHEN EXP COMMAND NOT WORKING
Goto Forum:
  


Current Time: Tue Aug 22 13:52:50 CDT 2017

Total time taken to generate the page: 0.09218 seconds