This discussion is archived
9 Replies Latest reply: Feb 12, 2013 4:10 AM by pradip010189 RSS

EXPDP error

pradip010189 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points