Site icon Bugra Parlayan | Oracle Database Blog

ORA-39095: Dump File Space Has Been Exhausted: Unable To Allocate

ERROR :

While running data pump with filesize parameter, got below error

$ expdp dumpfile=DBABUZER.dmp logfile=DBABUZER.log directory=DP_DIR filesize=500m full=y
 
Starting "SYS"."SYS_EXPORT_FULL_01":  /******** AS SYSDBA dumpfile=DBABUZER.dmp logfile=DBABUZER.log directory=DP_DIR filesize=500m full=y
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 349.5 MB
 
. . exported "SYS"." ******* "                      9.237 KB       1 rows
. . exported "SYS"." ****** "                       0 KB           0 rows
. . exported "WMSYS"." *******                      11.248 KB       3 rows
ORA-39095: Dump file space has been exhausted: Unable to allocate 4096 bytes
Job "SYS"."SYS_EXPORT_FULL_01" stopped due to fatal error at ....
 

SOLUTION :

FILE SIZE parameter limits the size of the dump file to the mentioned size. of the dump size exceeds that size, it will fail with ORA-39095 error.

Increase the value of filesize parameter &
Use wild character in dumpfile parameter as ABUZER_%U.dmp, so that it can generate multiple dumps

$ expdp dumpfile=DBABUZER_%U.dmp logfile=DBABUZER.log directory=DP_DIR filesize=500m full=y
Exit mobile version