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
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.
Thanks for the comment, that’s very helpful and you are right that it’s more of a workaround. Thanks for suggesting a good solution, I think it will help others.
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