Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
The following error is received when running the datapump with the file size parameter.
ERROR :
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | $ 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.
1 | $ expdp dumpfile=DBABUZER_%U.dmp logfile=DBABUZER.log directory=DP_DIR filesize=500m full=y |
