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