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 |
