DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: export errors

  1. #1
    Join Date
    Oct 2003
    Posts
    312

    export errors

    I have this error on my export:

    EXP-00056: ORACLE error 68 encountered

    ORA-00068: invalid value 1000000 for parameter sort_area_size, must be between 131072 and 0

    EXP-00056: ORACLE error 68 encountered

    ORA-00068: invalid value 1000000 for parameter sort_area_size, must be between 131072 and 0

    EXP-00000: Export terminated unsuccessfully





    I have 6 diffrent instances running on this server and all of the other ones are running ok except this one.

    any thought the problems???

  2. #2
    Join Date
    Jan 2001
    Posts
    3,134
    Where and when are you setting sort_area_size?

    Are you using a parfile?
    Can we see it?

    MH
    I remember when this place was cool.

  3. #3
    Join Date
    Oct 2003
    Posts
    312
    I don't have a parfile but it's just a simple export with the file nothing special here.

    sort_area_size=524000

  4. #4
    Join Date
    Jan 2001
    Posts
    3,134
    That is wierd, I have never heard of a sort_area problem with an export. There is no such export parameter.

    Can you use a parfile?
    What type (full, user, table) of export is this?
    I remember when this place was cool.

  5. #5
    Join Date
    Oct 2003
    Posts
    312
    I mean:

    exp system/manager file=blah.dmp log=blah.log full=y

    I research in Metalink and it said change the number of LOG_FILES to be compatible and I am not sure what LOG_FILES they are referrign to

  6. #6
    Join Date
    Nov 2001
    Location
    Planet Earth
    Posts
    116
    change you SORT_AREA_SIZE value between 131072 and 0, it shud be okay

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