Home » RDBMS Server » Server Utilities » IMP-00018: partial import of previous table completed: 491505 rows imported (oracle10g,Linux)
IMP-00018: partial import of previous table completed: 491505 rows imported [message #299831] Wed, 13 February 2008 06:01 Go to next message
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
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.

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 Go to previous message
joy_division
Messages: 4641
Registered: February 2005
Location: East Coast USA
Senior Member
Also, some OS's cannot handle a file larger than 2gb for import.
Previous Topic: convert .txt to .dbf and vice versa
Next Topic: imp a schema from oracle 9i Mac to Oracle 9i XP
Goto Forum:
  


Current Time: Wed Dec 07 12:45:33 CST 2016

Total time taken to generate the page: 0.15717 seconds