ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytesJob “SYS”.”SYS_EXPORT_FULL_02″ stopped due to fatal error

While exporting full database with multiple files per set and degree of parallelism,we encounter the ORA-39095 error

[oracle@orcl12x base]$ oerr ora 39095
39095, 00000, "Dump file space has been exhausted: Unable to allocate %s bytes"
// *Cause:  The Export job ran out of dump file space before the job was
//          completed.
// *Action: Reattach to the job and add additional dump files to the job
//          restarting the job.


Specify the size of each dump file in units of bytes.

The parameter value should be increased as per the total size of the object or database

eg: If database size is 1GB,then filesize per set = 100MB and degree of parallel = 10

which is 100 * 100MB/10 DOP = 100 MB per thread of CPU will be utilized

2)we forget to specify %U character on the dumpfile which spawn multiple jobs each process per file

eg: dumpfile=orcl19x_%U.dmp

Leave a Reply