OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » IMP-00028 (oracle 10g r2 , windows 2003 server 64 bit)

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

IMP-00028 [message #354897]

Tue, 21 October 2008 22:36

RAY_HT
Messages: 155
Registered: May 2005
Location: Giza

Senior Member

dear all

i have dump file size more than 5 GB .
when i tried to import it into new user the last table import process stoped with error :
IMP-00028
i tried IMP command with Commit=y option but it commited for 5 million recored while the table should contain more than 10 million record .

any one have the solution ???

thanks

Report message to a moderator

Re: IMP-00028 [message #354907 is a reply to message #354897]

Tue, 21 October 2008 23:29

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

IMP-00028: partial import of previous table rolled back: %lu rows rolled back
 *Cause:  Import encountered an Oracle error while trying to import a table.
 *Action: Look up the accompanying Oracle message in the ORA message
          chapters of this manual and take appropriate action. Then, if
          necessary, re-import the table.

Regards
Michel

Report message to a moderator

Re: IMP-00028 [message #354912 is a reply to message #354897]

Tue, 21 October 2008 23:42

RAY_HT
Messages: 155
Registered: May 2005
Location: Giza

Senior Member

i read this lines many times till now BUT
no ORA error raised , just IMP-00009 and IMP-00028.

the import stop after 5 million record .

thanks

Report message to a moderator

Re: IMP-00028 [message #354934 is a reply to message #354912]

Wed, 22 October 2008 00:34

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

IMP-00009: abnormal end of export file
 *Cause:  The export file is probably from an aborted Export session.
 *Action: If so, retry the export and import. Otherwise, report this as an
          Import bug and submit the export file that caused this error to
          customer support.

If you don't post more we can't help more.

Regards
Michel

Report message to a moderator

Previous Topic:	Export to dump file with low space.
Next Topic:	Imp

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 20:34:47 CST 2024