{"id":7600,"date":"2018-06-20T21:20:07","date_gmt":"2018-06-20T13:20:07","guid":{"rendered":"http:\/\/rmohan.com\/?p=7600"},"modified":"2018-06-20T21:20:07","modified_gmt":"2018-06-20T13:20:07","slug":"exp-00002-error-in-writing-to-export-file","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=7600","title":{"rendered":"EXP-00002: error in writing to export file"},"content":{"rendered":"<h3 class=\"post-title entry-title\">EXP-00002: error in writing to export file<\/h3>\n<div class=\"post-header\">\n<div class=\"post-header-line-1\"><\/div>\n<\/div>\n<div id=\"post-body-3523036979850269813\" class=\"post-body entry-content\">\n<div dir=\"ltr\">\n<div><\/div>\n<div>While exporting table or schema using exp\/imp utility you may come across below error.<\/div>\n<div><\/div>\n<div>Most of the time this error occurs due to\u00a0insufficient\u00a0space available on disk.so confirm space\u00a0is\u00a0available\u00a0where you are taking taking export dump and re-run export.<\/div>\n<div><\/div>\n<div><\/div>\n<div><b>[oracle@DEV admin]$ exp test\/test@DEV tables=t1,t2,t3,t4 file=exp_tables.dmp log=exp_tables.log<\/b><\/div>\n<div><\/div>\n<div>Export: Release 9.2.0.8.0 &#8211; Production on Thu Sep 10 12:25:52 2015<\/div>\n<div><\/div>\n<div>Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.<\/div>\n<div><\/div>\n<div><\/div>\n<div>Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 &#8211; Production<\/div>\n<div>With the Partitioning, OLAP and Oracle Data Mining options<\/div>\n<div>JServer Release 9.2.0.8.0 &#8211; Production<\/div>\n<div>Export done in US7ASCII character set and AL16UTF16 NCHAR character set<\/div>\n<div><\/div>\n<div>About to export specified tables via Conventional Path &#8230;<\/div>\n<div>. . exporting table t1 1270880 rows exported<\/div>\n<div>. . exporting table t2 2248883 rows exported<\/div>\n<div>. . exporting table t3 2864492 rows exported<\/div>\n<div>. . exporting table t4<\/div>\n<div>EXP-00002: error in writing to export file<\/div>\n<div>EXP-00002: error in writing to export file<\/div>\n<div>EXP-00000: Export terminated unsuccessfully<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>EXP-00002: error in writing to export file While exporting table or schema using exp\/imp utility you may come across below error. Most of the time this error occurs due to insufficient space available on disk.so confirm space is available where you are taking taking export dump and re-run export. [oracle@DEV admin]$ exp test\/test@DEV tables=t1,t2,t3,t4 file=exp_tables.dmp [&#8230;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[34],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/7600"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7600"}],"version-history":[{"count":1,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/7600\/revisions"}],"predecessor-version":[{"id":7601,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/7600\/revisions\/7601"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7600"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7600"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7600"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}