Home » RDBMS Server » Server Utilities » Reg IMP-00009: abnormal end of export file (oracle 10g)
Reg IMP-00009: abnormal end of export file [message #321102] Mon, 19 May 2008 01:38 Go to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi
While importing the dump file ,i am getting the below error
pls any help regarding this issue,

imp system/simple@orchid file=exp.dmp log=x.log fromuser=mas touser=mas commit =y buffer=1000000000

import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
. importing MASDEV's objects into MASDEV
. . importing table                   "ACLENTRIES"          0 rows imported
. . importing table               "ADHOC_CAPACITY"         42 rows imported
. . importing table           "ADHOC_CAPACITY_DTL"         58 rows imported
. . importing table      "AGGREGATE_BOOKING_TRANS"          0 rows imported
. . importing table               "AIRCRAFT_GROUP"          5 rows imported
. . importing table                "AIRCRAFT_TYPE"         88 rows imported
. . importing table     "AIRCRAFT_TYPE_ALT_CONFIG"         74 rows imported
. . importing table "AIRCRAFT_TYPE_ALT_CONFIG_DTL"        281 rows imported
. . importing table     "AIRCRAFT_TYPE_CONFIG_DTL"         50 rows imported
. . importing table            "AIRCRAFT_TYPE_MAP"         63 rows imported
.
.
.
.
.
.
.
. . 
importing partition "MTDAILY_FINAL_DEMAND_ROUTE_LEG":"PARTITION_22"     490508 rows imported
. . importing partition "MTDAILY_FINAL_DEMAND_ROUTE_LEG":"PARTITION_23"
IMP-00009: abnormal end of export file
IMP-00018: partial import of previous table completed: 229369 rows imported
Import terminated successfully with warnings.



Thanks,
Re: Reg IMP-00009: abnormal end of export file [message #321116 is a reply to message #321102] Mon, 19 May 2008 02:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
IMP-00009: abnormal end of export file

You file is corrupted or this was a multi-files export and you miss some.

Regards
Michel
Re: Reg IMP-00009: abnormal end of export file [message #321221 is a reply to message #321102] Mon, 19 May 2008 08:19 Go to previous message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Also possible that export file is larger than 2Gb and your O/S and Oracle combination will not import past the 2Gb limit.
Previous Topic: exp-00003 no storage definition found for the segment (7, 255)
Next Topic: how to import an encrypted export file
Goto Forum:
  


Current Time: Fri May 17 03:12:22 CDT 2024