Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2002
    Posts
    20

    Unanswered: Out of memory running imp80

    I'm facing something strange

    One of my customer sent me an Oracle 8.0.5 database dump and when i use imp80 to retrieve the data, my computer memory suddenly runs out of virtual memory
    The dump file size is about 120Mo
    It seems as if that imp80 loads the whole file before importing

    I used these different following command lines without success :

    imp80 system/manager file=export.dump fromuser=USER1 touser=USER1

    imp80 system/manager file=export.dump full=Y


    i'm not a DBA and don't know Oracle very much
    Any idea ?

  2. #2
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482
    Try,

    buffer=10000
    commit=y

    Hope that helps,

    Trifon Anguelov


  3. #3
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441
    could this not be that it is running out of space to sort the data (if it is indexed)?

    Have you tried a direct import?

  4. #4
    Join Date
    Mar 2002
    Posts
    20
    What is a direct import ?
    Sorry but i'm not a DBA as you've all noticed

Posting Permissions

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