Home » RDBMS Server » Server Utilities » IMP-00028 (oracle 10g r2 , windows 2003 server 64 bit)
IMP-00028 [message #354897] Tue, 21 October 2008 22:36 Go to next message
RAY_HT
Messages: 153
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
Re: IMP-00028 [message #354907 is a reply to message #354897] Tue, 21 October 2008 23:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: IMP-00028 [message #354912 is a reply to message #354897] Tue, 21 October 2008 23:42 Go to previous messageGo to next message
RAY_HT
Messages: 153
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
Re: IMP-00028 [message #354934 is a reply to message #354912] Wed, 22 October 2008 00:34 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Export to dump file with low space.
Next Topic: Imp
Goto Forum:
  


Current Time: Sat Dec 03 20:36:57 CST 2016

Total time taken to generate the page: 0.14895 seconds