:

ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes

The Problem

When running a data pump export job, I received the following error message:

ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes
Job “SYS”.”SYS_EXPORT_TABLE_01″ stopped due to fatal error at 12:09:55

The Cause

Because I wanted to make my imports faster I had set the parallel parameter on the import to try and improve import performance. This was the cause of the error, it turned out.

The Solution

I simply removed the parallel parameter from the data pump import parameter file and it worked without any further problems.

Like it, share it...

Category: Data Pump


Related Posts

Comments (3)

Trackback URL | Comments RSS Feed

  1. ndefontenay says:

    This is not really a solution. It’s more of a work around.
    What would happen if you really needed to use paralell?

    The solution is to use %U in your filename:
    expdp dumpfile=myschema__%U.dmp schemas=Whatever,you,need

    This will create a file with an increment value at the end produced by %U.

  2. Thanks for your comment. You are right it is more of a workaround rather than a solution. Thanks for sharing your answer, I’m sure that it will help many other people.

    Cheers,
    Rob

Leave a Reply

Your email address will not be published. Required fields are marked *