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

Thread: Errors during export

  1. #1
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Hello on my 816 hp unix environment
    i received the following error messages.

    EXP-00015: error on row 630912 of table HI_FGI_BAL_HISTORY, column HI_AVAIL_ON_HAND, datatype 2
    EXP-00002: error in writing to export file
    EXP-00002: error in writing to export fileerror closing export file
    EXP-00000: Export terminated unsuccessfully

    can anybody give me ideas on how to possibly resolve this?I am new at this.

    thanks
    Jigar
    "High Salaries = Happiness = Project Success."

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You have an error writing to your export file. Usually, this is because of permissions, you have filled up a filesystem, or you have reached the maximum file size for your OS.
    Jeff Hunter

  3. #3
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Isnt there a way to export a full database compressed by itself?
    not compress the extents but compress the .exp.Z itself.

    thanks
    Jigar
    "High Salaries = Happiness = Project Success."

  4. #4
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Hello...i actually meant inline compression.
    "High Salaries = Happiness = Project Success."

  5. #5
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Any ideas from moderators?
    "High Salaries = Happiness = Project Success."

  6. #6
    Join Date
    Aug 2000
    Posts
    194
    check these links:

    http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=1057099.6

    http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=1038222.6

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    As far as I know you cannot compress a file that is being written, not just UNIX I dont think it's possible in any OS

  8. #8
    Join Date
    Jun 2001
    Posts
    132

    Smile

    If you are reaching your OS's file size limit or if disk space is scarce you can split your exports to make it smaller. you have 2 or more files to deal with but hey....you gotta do what you gotta do. If this is a backup you're creating I suggest you just do an online backup of the datafiles, it's faster and it solves your file size limit problem.
    You think I'm going to have an affair with you? --Stanley Kowalski

  9. #9
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    hi

    why not try to export directly to a tape device??

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