{"id":294,"date":"2024-12-13T10:55:37","date_gmt":"2024-12-13T09:55:37","guid":{"rendered":"https:\/\/oracledba.fr\/?p=294"},"modified":"2026-02-23T11:14:36","modified_gmt":"2026-02-23T10:14:36","slug":"ora-39097-ora-39065-ora-21780","status":"publish","type":"post","link":"https:\/\/oracledba.fr\/?p=294","title":{"rendered":"ORA-39097 ORA-39065 ORA-21780"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<p>expdp job is failing with the below error:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ORA-39097: Data Pump job encountered unexpected error -21780<br>ORA-39065: unexpected master process exception in DISPATCH<br>ORA-21780: Maximum number of object durations exceeded.<br>ORA-06512: at \"SYS.KUPM$MCP\", line 14382<br>ORA-06512: at \"SYS.KUPM$MCP\", line 12886<br>ORA-06512: at \"SYS.KUPM$MCP\", line 12565<br>ORA-06512: at \"SYS.KUPM$MCP\", line 15267<br>ORA-06512: at \"SYS.KUPM$MCP\", line 12619<br>ORA-06512: at \"SYS.KUPM$MCP\", line 15267<br>ORA-06512: at \"SYS.KUPM$MCP\", line 12619<br>ORA-06512: at \"SYS.KUPM$MCP\", line 15267<br>ORA-06512: at \"SYS.KUPM$MCP\", line 12619<br>ORA-06512: at \"SYS.KUPM$MCP\", line 15267<br>ORA-06512: at \"SYS.KUPM$MCP\", line 12619<br>ORA-06512: at \"SYS.KUPM$MCP\", line 15267<br>ORA-06512: at \"SYS.KUPM$MCP\", line 12619<br>ORA-06512: at \"SYS.KUPM$MCP\", line 15267<br>ORA-06512: at \"SYS.KUPM$MCP\", line 12619<br>ORA-06512: at \"SYS.KUPM$MCP\", line 15267<br>ORA-06512: at \"SYS.KUPM$MCP\", line 12619<br>ORA-06512: at \"SYS.KUPM$MCP\", line 15267<br>ORA-06512: at \"SYS.KUPM$MCP\", line 12619<br>ORA-06512: at \"SYS.KUPM$MCP\", line 15267<br>ORA-06512: at \"SYS.KUPM$MCP\", line 12619<br>ORA-06512: at \"SYS.KUPM$MCP\", line 15267<br>ORA-06512: at \"SYS.KUPM$MCP\", line 12619<br>ORA-06512: at \"SYS.KUPM$MCP\", line 15267<br>ORA-06512: at \"SYS.KUPM$MCP\", line 12619<br>ORA-06512: at \"SYS.KUPM$MCP\", line 15267<br>ORA-06512: at \"SYS.KUPM$MCP\", line 12619<br>ORA-06512: at \"SYS.KUPM$MCP\", line 15267<br>ORA-06512: at \"SYS.KUPM$MCP\", line 12619<br>ORA-06512: at \"SYS.KUPM$MCP\", line 15267<br>ORA-06512: at \"SYS.KUPM$MCP\", line 12619<\/pre>\n\n\n\n<p>The solution is to add the option exclude=STATISTICS\/MARKER .<\/p>\n\n\n\n<p>It can also be because temp file is missing from the temp tablespace<\/p>\n","protected":false},"excerpt":{"rendered":"<p>expdp job is failing with the below error: ORA-39097: Data Pump job encountered unexpected error -21780ORA-39065: unexpected master process exception in DISPATCHORA-21780: Maximum number of object durations exceeded.ORA-06512: at &#8220;SYS.KUPM$MCP&#8221;, line 14382ORA-06512: at &#8220;SYS.KUPM$MCP&#8221;, line 12886ORA-06512: at &#8220;SYS.KUPM$MCP&#8221;, line 12565ORA-06512: at &#8220;SYS.KUPM$MCP&#8221;, line 15267ORA-06512: at &#8220;SYS.KUPM$MCP&#8221;, line 12619ORA-06512: at &#8220;SYS.KUPM$MCP&#8221;, line 15267ORA-06512: at &#8220;SYS.KUPM$MCP&#8221;, line &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/oracledba.fr\/?p=294\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;ORA-39097 ORA-39065 ORA-21780&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-294","post","type-post","status-publish","format-standard","hentry","category-non-classe"],"_links":{"self":[{"href":"https:\/\/oracledba.fr\/index.php?rest_route=\/wp\/v2\/posts\/294","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oracledba.fr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracledba.fr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracledba.fr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oracledba.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=294"}],"version-history":[{"count":3,"href":"https:\/\/oracledba.fr\/index.php?rest_route=\/wp\/v2\/posts\/294\/revisions"}],"predecessor-version":[{"id":309,"href":"https:\/\/oracledba.fr\/index.php?rest_route=\/wp\/v2\/posts\/294\/revisions\/309"}],"wp:attachment":[{"href":"https:\/\/oracledba.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=294"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracledba.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=294"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracledba.fr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=294"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}