EXP 00015 error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: EXP 00015 error

  1. #1
    Join Date
    Apr 2001
    Posts
    16

    Red face

    I am geting the following error while taking an export of certain tables.

    EXP-00015: error on row 4529454 of table CUST_STATUS_HISTORY, column INSERT_DT, datatype 12
    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 provide a solution.

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    do :

    select insert_dt
    from cust_status_history
    where rowid = (
    select rowid from cust_status_history
    where rownum <= 4529454
    minus
    select rowid from cust_status_history
    where rownum < 4529454)

    and you'll get the data which caused a problem ...
    note that the error might be caused by the OS, not exp. was the filesystem (or HD) full ???

  3. #3
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    maybe you just hit the maximum file size allowed, and that you can no longer continue such task if your O.S. doesn't allow to enable large file system.
    What is the actual size of the exp dump file?

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