Home » RDBMS Server » Server Utilities » IMP-00009 + IMP-00028 (Oracle 10.2.0.1, OS- Solaris 5.10)
IMP-00009 + IMP-00028 [message #300287] Thu, 14 February 2008 22:35 Go to next message
kamragulshan
Messages: 63
Registered: May 2005
Location: Delhi
Member
Hi

I have a dump of 9GB. I am importing the dump using below command:

imp system file=active01.dmp,active02.dmp,active03.dmp,..............,active18.dmp log=imp_120208.log  full=y


But i got the below error:

IMP-00009: abnormal end of export file
IMP-00028: partial import of previous table rolled back: 9808336 rows rolled back
Import terminated successfully with warnings.


I have tried to import the dump again using:

imp system file=active01.dmp,active02.dmp,active03.dmp,..............,active18.dmp log=imp_120208.log  buffer=40000000 full=y

imp userid=system file="active1.dmp,active2.dmp,................,active18.dmp log=imp_140208.log filesize=524288000 full=y


But again and again i am getting the same error.

We have requested the client to provide the dump again as might be there is some corruption in the dumpfile. So client has provide the dump again but still we are getting the same errors.

Please suggest to resolve the issue.

Thanks
Gulshan
Re: IMP-00009 + IMP-00028 [message #300297 is a reply to message #300287] Thu, 14 February 2008 23:08 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> So client has provide the dump again
How exactly?
FTP? Did you use bin option?
How was the export done? Conventional or direct path?
Is there a difference in Source / target versions?
Re: IMP-00009 + IMP-00028 [message #300309 is a reply to message #300287] Thu, 14 February 2008 23:39 Go to previous messageGo to next message
kamragulshan
Messages: 63
Registered: May 2005
Location: Delhi
Member
Hi Mahesh,

Client used to sent the dump files through ftp and we always use binary mode to download the files.

Client used to send the files on weekly basis.

We are not aware about the Oracle version used at client side but earlier also client sent the dump file and we did not face any problem.

This is the first time we are getting this error.

Thanks
Gulshan
Re: IMP-00009 + IMP-00028 [message #300374 is a reply to message #300287] Fri, 15 February 2008 04:16 Go to previous messageGo to next message
Uwe
Messages: 260
Registered: February 2003
Location: Z├╝rich, Switzerland
Senior Member
Did you try to import file by file to see which one may be corrupted / not ended correctly ?
Re: IMP-00009 + IMP-00028 [message #300383 is a reply to message #300287] Fri, 15 February 2008 04:42 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you have all the dump files?
Did you have any error during export?

Regards
Michel
Previous Topic: Import
Next Topic: Text File To Dbf in oracle using java code or pl/sql code
Goto Forum:
  


Current Time: Sun Dec 04 10:34:34 CST 2016

Total time taken to generate the page: 0.20378 seconds