Home » RDBMS Server » Backup & Recovery » when i am trying to import files in ora9i, I am getting the following error.
when i am trying to import files in ora9i, I am getting the following error. [message #397299] Thu, 09 April 2009 23:48 Go to next message
sandeepkadre
Messages: 3
Registered: April 2009
Junior Member

when i am trying to import files in ora9i, I am getting the following error.

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

Its very urgent and i am not getting the solution from last night...

Please any one can provide the exact solution for it....

Regards
Sandeep
9850839153
Re: when i am trying to import files in ora9i, I am getting the following error. [message #397300 is a reply to message #397299] Thu, 09 April 2009 23:54 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Such as sad, sorry, & weak post.

You have a problem & provide no useful details to assist you.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Please, please, please Read & Follow Posting Guidelines above.
Go to the section labeled "Practice" & do as directed.
Re: when i am trying to import files in ora9i, I am getting the following error. [message #397301 is a reply to message #397300] Fri, 10 April 2009 00:03 Go to previous messageGo to next message
sandeepkadre
Messages: 3
Registered: April 2009
Junior Member

imp user/user@DBA

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.
Re: when i am trying to import files in ora9i, I am getting the following error. [message #397302 is a reply to message #397299] Fri, 10 April 2009 00:09 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>when i am trying to import files in ora9i,
So you claim.

Please realize we have NO idea, clue, observation that you have.

Yes, you are getting errors.

From what environment was export taken? Provide proof.

Into what environment is import being attempted? Provide proof.
Re: when i am trying to import files in ora9i, I am getting the following error. [message #397312 is a reply to message #397301] Fri, 10 April 2009 00:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
It seems that either:
1/ your dump file is corrupted
2/ your dump file is truncated
3/ your dump file is part of a set of dump files and you didn't give the following ones
4/ ...?

Regards
Michel
Re: when i am trying to import files in ora9i, I am getting the following error. [message #397346 is a reply to message #397312] Fri, 10 April 2009 03:28 Go to previous messageGo to next message
sandeepkadre
Messages: 3
Registered: April 2009
Junior Member

Thanks for your reply..

I have taken backup again but it shows the same error while importing it.

Re: when i am trying to import files in ora9i, I am getting the following error. [message #397348 is a reply to message #397346] Fri, 10 April 2009 03:33 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
As you have posted no more information, you have no more answer.

Quote:
Please realize we have NO idea, clue, observation that you have.

Yes, you are getting errors.

From what environment was export taken? Provide proof.

Into what environment is import being attempted? Provide proof.


Regards
Michel
Previous Topic: Offline Backup
Next Topic: Backup Control file
Goto Forum:
  


Current Time: Mon Nov 25 12:19:36 CST 2024