Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    7

    Unanswered: Help EXP-0002 on 9.2.0.4

    I can't understand why my export is terminating early. I have plently of space on the disk and I have read permissions....any Ideas?

    JServer Release 9.2.0.4.0 - Production
    Export done in US7ASCII character set and AL16UTF16 NCHAR character set
    server uses WE8ISO8859P1 character set (possible charset conversion)
    EXP-00002: error in writing to export file
    EXP-00000: Export terminated unsuccessfully


    thanks

  2. #2
    Join Date
    Jan 2004
    Posts
    370
    How far into the export are you getting before it fails?
    Are there any additional operating system errors reported?

  3. #3
    Join Date
    Mar 2004
    Posts
    7
    At the very begining....its works with SYSTEM , but anyother DBA user it will fail. I am thinking I have a problem with a view or package?

  4. #4
    Join Date
    Jan 2004
    Posts
    370
    You have a problem with writing to the file.

    EXP-00002: error in writing to export file

    Were there any operating system errors reported?

    At the very begining....its works with SYSTEM , but anyother DBA user it will fail.
    Are you saying the export completes successfully as system?
    And you get this error when you export as another user?

    How exactly are you doing the export?
    Are you specifying a log file?

  5. #5
    Join Date
    Mar 2004
    Posts
    7
    Thanks, for your help!

    I ended up fixing the problem.
    Seems that I had a private table DUAL for the dba user doing the export. This is why I could have exported with SYSTEM. It works now, full/owner , row=n/y....

Posting Permissions

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