OraFAQ Forum: Server Utilities » IMP-00009 + IMP-00028

Home » RDBMS Server » Server Utilities » IMP-00009 + IMP-00028 (Oracle 10.2.0.1, OS- Solaris 5.10)

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

IMP-00009 + IMP-00028 [message #300287]

Thu, 14 February 2008 22:35

kamragulshan
Messages: 66
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

Report message to a moderator

Re: IMP-00009 + IMP-00028 [message #300297 is a reply to message #300287]

Thu, 14 February 2008 23:08

Mahesh Rajendran
Messages: 10707
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?

Report message to a moderator

Re: IMP-00009 + IMP-00028 [message #300309 is a reply to message #300287]

Thu, 14 February 2008 23:39

kamragulshan
Messages: 66
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

Report message to a moderator

Re: IMP-00009 + IMP-00028 [message #300374 is a reply to message #300287]

Fri, 15 February 2008 04:16

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 ?

Report message to a moderator

Re: IMP-00009 + IMP-00028 [message #300383 is a reply to message #300287]

Fri, 15 February 2008 04:42

Michel Cadot
Messages: 68658
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 09 01:17:09 CDT 2024