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.

Solution:

1)FILESIZE
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

Published by kishan

You will know about me.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: