DataPump Export (EXPDP) Error ORA-39095 Dump File Space Has Been Exhausted
ORA - 39095 : " dump file space has been exhausted. Unable to allocate 8192 bytes"
job system.sys_export_full_02 stops due to fatal error.
job system.sys_export_full_02 stops due to fatal error.
cause:
Not enough number of dump files defined
Not enough number of dump files defined
expdp can create maximum 99 dumpfiles so if you are exporting very large database ensure to define filesize big enough so the total export can fit in <=99 dumpfiles
The issue can also occur if you specify the dumpfiles manually for example if your parfile looks like this
full=Y
directory=<DIRECTORY_NAME>
dumpfile=full_1.dmp,full2_2.dmp,full_3.dmp
filesize=10
directory=<DIRECTORY_NAME>
dumpfile=full_1.dmp,full2_2.dmp,full_3.dmp
filesize=10
if export did not finish in 3 dumpfiles and need to created 4th one you will receive the error
ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes
Job "SYSTEM"."sys_export_full_02" stopped due to fatal error at Wed Oct 7 21:13:55 2020 elapsed 0 10:09:02
Job sys_export_full_02 has been reopened at Thu Oct 8 09:14:03 2020
Comments
Post a Comment