9 Replies Latest reply on Feb 12, 2013 12:10 PM by pradip010189

    EXPDP error

      Hello Friends,

      I want to take backup using Datapump (Expdp) utility.
      When ever i fire below command it will start without any issue.

      Command: expdp system@SERVICENAME schemas=MYSCHEMA directory=BACKUP_DIR dumpfile=dump.dmp logfile=LOG.log

      when dump file size will reach to 4GB. It gives me below error:

      ORA-31693: Table data object "MYSCHEMA"."MYTABLE":"TAP_3" failed to load/unload and is being skipped due to error:
      ORA-19502: write error on file "dump.dmp", blockno 1048522 (blocksize=4096)
      ORA-27072: File I/O error
      OSD-04008: WriteFile() failure, unable to write to file
      O/S-Error: (OS 112) There is not enough space on the disk.
      ORA-39125: Worker unexpected fatal error in KUPW$WORKER.DISPATCH_WORK_ITEMS while calling KUPF$FILE.RELEASE_FILES [TABLE_DATA:"MYSCHEMA"."MYTABLE":"TAP_3"]
      ORA-31643: unable to close dump file "dump.dmp"
      ORA-19510: failed to set size of 1048713 blocks for file "dump.DMP" (blocksize=4096)
      ORA-27059: could not reduce file size
      OSD-04005: SetFilePointer() failure, unable to read from file
      O/S-Error: (OS 112) There is not enough space on the disk.
      ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
      ORA-06512: at "SYS.KUPW$WORKER", line 6313

      On my disk there are 100GB space available and in log file it shows total size consume by file will be "Total estimation using BLOCKS method: 16.78 GB".

      Please help to solve this problem.

      Thanks & Regards,
      Pradip Patel