OraFAQ Forum: Server Utilities » IMP-00018: partial import of previous table completed: 491505 rows imported

Home » RDBMS Server » Server Utilities » IMP-00018: partial import of previous table completed: 491505 rows imported (oracle10g,Linux)

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

IMP-00018: partial import of previous table completed: 491505 rows imported [message #299831]

Wed, 13 February 2008 06:01

sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai

Senior Member

Hi,
During the import in schema i got error like

IMP-00009: abnormal end of export file
IMP-00018: partial import of previous table completed: 491505 rows imported
Import terminated successfully with warnings.

My import command:

imp system/simple@maple file=exp_lanmtdemo_robin_feb04.dmp log=lanmtdemo.log fromuser=lanmtdemo
touser=lanmtdemo commit=y buffer=1000000000

Thanks,
Michael

Report message to a moderator

Re: IMP-00018: partial import of previous table completed: 491505 rows imported [message #299849 is a reply to message #299831]

Wed, 13 February 2008 06:32

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>IMP-00009: abnormal end of export file
May be your dmp file is corrupt.
Did you ftp the file? Edit it?
And, not related to this issue
with commit=y , you are inviting trouble.

Report message to a moderator

Re: IMP-00018: partial import of previous table completed: 491505 rows imported [message #299872 is a reply to message #299831]

Wed, 13 February 2008 08:07

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Also, some OS's cannot handle a file larger than 2gb for import.

Report message to a moderator

Previous Topic:	convert .txt to .dbf and vice versa
Next Topic:	imp a schema from oracle 9i Mac to Oracle 9i XP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 22:20:09 CST 2024