{"id":982,"date":"2020-02-27T15:31:59","date_gmt":"2020-02-27T18:31:59","guid":{"rendered":"http:\/\/rodrigosilvaesilva.com.br\/?p=982"},"modified":"2020-02-27T15:31:59","modified_gmt":"2020-02-27T18:31:59","slug":"erro-ora-39213-metadata-processing-is-not-available-expdp-oracle-11","status":"publish","type":"post","link":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/2020\/02\/27\/erro-ora-39213-metadata-processing-is-not-available-expdp-oracle-11\/","title":{"rendered":"Erro ORA-39213: Metadata processing is not available expdp Oracle 11"},"content":{"rendered":"<p>Erro ao realizar export Oracle 11.2.0.4 em Windows Server<\/p>\n<p><strong>Problema:<\/strong><\/p>\n<pre class=\"lang:sh decode:true\">C:\\Users\\Administrador&gt;expdp '\/ as sysdba' schemas=PROD,TESTE directory=BKPDIR statistics=none dumpfile=EXP_27022020.dmp logfile=EXP_27022020.log\n\nExport: Release 11.2.0.2.0 - Production on Qui Fev 27 15:13:18 2020\n\nCopyright (c) 1982, 2009, Oracle and\/or its affiliates.  All rights reserved.\n\nConectado a: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Productio\n\nORA-39006: internal error\nORA-39213: Metadata processing is not available\n<\/pre>\n<p><strong>Causa:<\/strong><\/p>\n<p>O datapump n\u00e3o consegue utilizar API<\/p>\n<p><strong>Solu\u00e7\u00e3o<\/strong><\/p>\n<p>Conecte no sqlplus como sysdba e execute<\/p>\n<pre class=\"lang:plsql decode:true  \">execute sys.dbms_metadata_util.load_stylesheets;<\/pre>\n<p><strong>Resolvido<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Erro ao realizar export Oracle 11.2.0.4 em Windows Server Problema: C:\\Users\\Administrador&gt;expdp &#8216;\/ as sysdba&#8217; schemas=PROD,TESTE directory=BKPDIR statistics=none dumpfile=EXP_27022020.dmp logfile=EXP_27022020.log Export: Release 11.2.0.2.0 &#8211; Production on Qui Fev 27 15:13:18 2020 Copyright (c) 1982, 2009, Oracle and\/or its affiliates. All rights reserved. Conectado a: Oracle Database 11g Express Edition Release 11.2.0.2.0 &#8211; Productio ORA-39006: internal error&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[266,267,279,342,343],"class_list":["post-982","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-ora-39006-ora-39213","tag-ora-39006-internal-error","tag-ora-39213-metadata-processing-is-not-available","tag-sys-dbms_metadata","tag-sys-dbms_metadata_util-load_stylesheets"],"_links":{"self":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/982","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=982"}],"version-history":[{"count":0,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/982\/revisions"}],"wp:attachment":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=982"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=982"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=982"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}