Urgent, IMP-00009, abnormal end of file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Urgent, IMP-00009, abnormal end of file

  1. #1
    Join Date
    Nov 2000
    Posts
    79
    Hi everyone,

    I am trying to import into 8.1.7 the export file from oracle 7.3 and it runs into an error IMP-00009 abnormal end of file.
    Is it becuase of the different version of oracle
    or there could be problem with the export file itself.

    I would really appreciate your help.

    Thank,

    gtm

  2. #2
    Join Date
    Mar 2001
    Posts
    635
    Hi

    The dmp file corrupted for some reason

    Regards
    Santosh

  3. #3
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    goto Oracles' metalink and click on technical libraries from there click on Oracle server and it will give some white papers on imp/exp between databases.
    "High Salaries = Happiness = Project Success."

  4. #4
    Join Date
    Jan 2001
    Posts
    3,131
    I'm glad I can share my Revelanet with all of you;

    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 Oracle Customer Support.


    You can actually get this info from oracle's web page, just search on it.
    MH

  5. #5
    Join Date
    Nov 2000
    Posts
    79
    Thanks everyone for help.

    I have asked the client to send another file. I tried to find the information on metalink, as you have suggested, it could be due to corruption or abonormal export.

    But for sending export back to oracle7.3, i would have to run CATEXP7.sql in 8i database. I hope it works.



    Thanks,
    gtm



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width