{"id":962,"date":"2024-12-27T21:01:59","date_gmt":"2024-12-27T21:01:59","guid":{"rendered":"https:\/\/w3buddy.com\/?p=962"},"modified":"2026-01-15T13:15:45","modified_gmt":"2026-01-15T07:45:45","slug":"how-to-fix-ora-39095-dump-file-space-exhausted","status":"publish","type":"post","link":"https:\/\/w3buddy.com\/blog\/how-to-fix-ora-39095-dump-file-space-exhausted\/","title":{"rendered":"How to Fix ORA-39095: Dump File Space Has Been Exhausted"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">To fix the <strong>ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes<\/strong> error, you can follow these steps:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1. <strong>Use Dynamic Dump File Names with Wildcard <code>%U<\/code><\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The primary solution is to use a dynamic dump file name with the %U wildcard. This allows Data Pump to automatically create multiple dump files, splitting the export job across several smaller files and ensuring you don&#8217;t run out of space.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Example:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-sql\">expdp your_user\/password DIRECTORY=your_directory DUMPFILE=my_export_files_%U.dmp LOGFILE=my_export_log.log<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">In this case:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Data Pump will create multiple dump files with names like <strong>my_export_files_01.dmp<\/strong>, <strong>my_export_files_02.dmp<\/strong>, and so on.<\/li>\n\n\n\n<li>It will automatically distribute the data across multiple files, preventing the dump file from exceeding disk space.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">2. <strong>Limit the Size of Each Dump File (Optional)<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">You can also limit the size of each dump file using the <code>FILESIZE<\/code> parameter. This ensures that no single dump file becomes too large, which can help manage disk space more efficiently.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Example:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-sql\">expdp your_user\/password DIRECTORY=your_directory DUMPFILE=my_export_files_%U.dmp LOGFILE=my_export_log.log FILESIZE=2G<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This will split the export into files, each of a maximum size of 2GB.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">3. <strong>Check Disk Space<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Ensure that the directory specified for the dump files has enough available disk space. If necessary, free up space or specify a different directory that has sufficient capacity.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You can check the available disk space on the server using commands like:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Linux\/Unix:<\/strong> df -h<\/li>\n\n\n\n<li><strong>Windows:<\/strong> dir<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">If the disk is full, free up some space or change the dump directory to another location with more available space.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">4. <strong>Check Temporary Tablespace<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">If there is insufficient space in the temporary tablespace, it may also cause the error. Make sure there is enough space in the temporary tablespace used by Data Pump for sorting operations. You can query the available space in the temporary tablespace with the following SQL:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-sql\">SELECT   A.tablespace_name tablespace, D.mb_total,\nSUM (A.used_blocks * D.block_size) \/ 1024 \/ 1024 \/ 1024 GB_used,\nD.mb_total - SUM (A.used_blocks * D.block_size) \/ 1024 \/ 1024 \/ 1024 GB_free\nFROM     v$sort_segment A,\n(\nSELECT   B.name, C.block_size, SUM (C.bytes) \/ 1024 \/ 1024 \/ 1024\nmb_total\nFROM     v$tablespace B, v$tempfile C\nWHERE    B.ts#= C.ts#\nGROUP BY B.name, C.block_size\n) D\nWHERE    A.tablespace_name = D.name\nGROUP by A.tablespace_name, D.mb_total;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">If necessary, add more space to the temporary tablespace:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-\">ALTER DATABASE TEMPFILE '\/path\/to\/tempfile.dbf' RESIZE 2G;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">5. <strong>Monitor and Adjust Resource Usage<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Use the PARALLEL parameter to improve the performance of the export operation and reduce the space required by spreading the load across multiple processes.<\/li>\n\n\n\n<li>You can also use the COMPRESSION parameter to reduce the size of the dump files during the export process.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Example with PARALLEL:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-sql\">expdp your_user\/password DIRECTORY=your_directory DUMPFILE=my_export_files_%U.dmp LOGFILE=my_export_log.log PARALLEL=4<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">By using the dynamic dump file names with %U, ensuring sufficient disk and temporary tablespace, and optionally limiting the file size with FILESIZE, you can resolve the ORA-39095 error effectively<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To fix the ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes error, you can follow these steps: 1. Use Dynamic Dump File Names with Wildcard %U The primary solution is to use a dynamic dump file name with the %U wildcard. This allows Data Pump to automatically create multiple dump files, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"googlesitekit_rrm_CAowu461DA:productID":"","footnotes":""},"categories":[1225],"tags":[],"class_list":["post-962","post","type-post","status-publish","format-standard","hentry","category-database"],"_links":{"self":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/962","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/comments?post=962"}],"version-history":[{"count":2,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/962\/revisions"}],"predecessor-version":[{"id":1559,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/962\/revisions\/1559"}],"wp:attachment":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/media?parent=962"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/categories?post=962"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/tags?post=962"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}