Oracle Hata Kodları

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
Etiketler

Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/classes/class-tielabs-filters.php on line 340

Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/classes/class-tielabs-filters.php on line 340

Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/functions/media-functions.php on line 114

Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/classes/class-tielabs-filters.php on line 340

Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/functions/media-functions.php on line 114

bparlayan

Blog sitemi boş zamanlarımda hem biraz karalamak hemde mesleki tecrübeleri paylaşmak için kullanmaktayım. Burası benim deşarj noktam. Bu paylaşımları istediğiniz gibi çoğaltabilir ve kullanabilirsiniz : ). Ufak bir teşekkür yeterli. bugra[@]bugraparlayan.com.tr adresinden iletişim kurabilirsiniz.

İlgili Makaleler

Bir yanıt yazın


Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/classes/class-tielabs-filters.php on line 340

Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/functions/media-functions.php on line 114

Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/classes/class-tielabs-filters.php on line 340

Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/functions/media-functions.php on line 114
Başa dön tuşu
Kapalı