OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Import error (Oracle10g,Linux)

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

Import error [message #287135]

Tue, 11 December 2007 03:13

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?

Report message to a moderator

Re: Import error [message #287141 is a reply to message #287135]

Tue, 11 December 2007 03:24

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

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

Report message to a moderator

Re: Import error [message #287196 is a reply to message #287135]

Tue, 11 December 2007 06:39

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

Report message to a moderator

Re: Import error [message #287237 is a reply to message #287135]

Tue, 11 December 2007 09:24

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

Report message to a moderator

Previous Topic:	Message 2100 not found;
Next Topic:	Only half the records from dat file is loaded into table using sqlldr

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 29 05:05:58 CDT 2024