{"id":1360,"date":"2015-03-30T23:09:33","date_gmt":"2015-03-31T02:09:33","guid":{"rendered":"http:\/\/www.dbarj.com.br\/?p=1360"},"modified":"2015-03-30T23:10:19","modified_gmt":"2015-03-31T02:10:19","slug":"impdp-falhando-com-ora-39083-e-ora-14024","status":"publish","type":"post","link":"https:\/\/www.dbarj.com.br\/pt-br\/2015\/03\/impdp-falhando-com-ora-39083-e-ora-14024\/","title":{"rendered":"IMPDP falhando com ORA-39083 e ORA-14024"},"content":{"rendered":"<p>\u00c0s vezes, quando o seu <span style=\"color: #0000ff;\"><strong>EXPDP<\/strong><\/span> leva muito tempo (provavelmente porque voc\u00ea tem grandes tabelas particionadas), when quando voc\u00ea tenta rodar o <span style=\"color: #0000ff;\"><strong>IMPDP<\/strong><\/span> em algum lugar mais tarde, voc\u00ea pode receber o erro:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">ORA-39083: Object type INDEX failed to create with error:\r\nORA-14024: number of partitions of LOCAL index must equal that of the underlying table<\/pre>\n<p>Isso geralmente acontece porque a exporta\u00e7\u00e3o dos metadados da tabela foi feita em um instante de tempo anterior aos metadados \u00edndice. Mesmo usando o\u00a0<strong>FLASHBACK_TIME<\/strong> <span style=\"color: #800000;\"><strong>n\u00e3o<\/strong><\/span>\u00a0far\u00e1 que voc\u00ea tenha uma exporta\u00e7\u00e3o consistente porque esta cl\u00e1usula est\u00e1 relacionada apenas ao SCN dos dados, n\u00e3o de metadados.<\/p>\n<p>Para evitar esse tipo de problema, a melhor abordagem \u00e9 parar qualquer atividade de usu\u00e1rio, job ou scheduled que est\u00e1 criando novas parti\u00e7\u00f5es ou qualquer outro tipo de modifica\u00e7\u00f5es nas estruturas dos objetos que voc\u00ea est\u00e1 exportando. Al\u00e9m disso, se voc\u00ea tem um ambiente Data Guard, voc\u00ea pode parar temporariamente o processo de aplica\u00e7\u00e3o de redos e tentar expdp do standby.<\/p>\n<p>Sendo assim, voc\u00ea vai ter um export consistente e n\u00e3o vai receber esse erro mais quando rodar o impdp.<\/p>\n<b>Gostou? N\u00e3o deixe de comentar ou deixar um \ud83d\udc4d!<\/b>\n<div class='watch-action'><div class='watch-position align-left'><div class='action-like'><a class='lbg-style2 like-1360 jlk' href='javascript:void(0)' data-task='like' data-post_id='1360' data-nonce='de4404f630' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.dbarj.com.br\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-1360 lc'>0<\/span><\/a><\/div><\/div> <div class='status-1360 status align-left'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>\u00c0s vezes, quando o seu EXPDP leva muito tempo (provavelmente porque voc\u00ea tem grandes tabelas particionadas), when quando voc\u00ea tenta rodar o IMPDP em algum lugar mais tarde, voc\u00ea pode receber o erro: ORA-39083: Object type INDEX failed to create with error: ORA-14024: number of partitions of LOCAL index must equal that of the underlying &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/www.dbarj.com.br\/pt-br\/2015\/03\/impdp-falhando-com-ora-39083-e-ora-14024\/\">Continue lendo<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1360","post","type-post","status-publish","format-standard","hentry","category-database","item-wrap"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>IMPDP falhando com ORA-39083 e ORA-14024 - DBA - Rodrigo Jorge - Oracle Tips and Guides<\/title>\n<meta name=\"description\" content=\"Como resolver o IMPDP falhando com ORA-39083 e ORA-14024\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbarj.com.br\/pt-br\/2015\/03\/impdp-falhando-com-ora-39083-e-ora-14024\/\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"DBA RJ\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. tempo de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2015\\\/03\\\/impdp-falhando-com-ora-39083-e-ora-14024\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2015\\\/03\\\/impdp-falhando-com-ora-39083-e-ora-14024\\\/\"},\"author\":{\"name\":\"DBA RJ\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"headline\":\"IMPDP falhando com ORA-39083 e ORA-14024\",\"datePublished\":\"2015-03-31T02:09:33+00:00\",\"dateModified\":\"2015-03-31T02:10:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2015\\\/03\\\/impdp-falhando-com-ora-39083-e-ora-14024\\\/\"},\"wordCount\":180,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"articleSection\":[\"Oracle Database General\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2015\\\/03\\\/impdp-falhando-com-ora-39083-e-ora-14024\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2015\\\/03\\\/impdp-falhando-com-ora-39083-e-ora-14024\\\/\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2015\\\/03\\\/impdp-falhando-com-ora-39083-e-ora-14024\\\/\",\"name\":\"IMPDP falhando com ORA-39083 e ORA-14024 - DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#website\"},\"datePublished\":\"2015-03-31T02:09:33+00:00\",\"dateModified\":\"2015-03-31T02:10:19+00:00\",\"description\":\"Como resolver o IMPDP falhando com ORA-39083 e ORA-14024\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2015\\\/03\\\/impdp-falhando-com-ora-39083-e-ora-14024\\\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2015\\\/03\\\/impdp-falhando-com-ora-39083-e-ora-14024\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/2015\\\/03\\\/impdp-falhando-com-ora-39083-e-ora-14024\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"IMPDP falhando com ORA-39083 e ORA-14024\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#website\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/\",\"name\":\"DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"description\":\"Blog about Databases, Security and High Availability\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/pt-br\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\",\"name\":\"DBA RJ\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"contentUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"width\":712,\"height\":712,\"caption\":\"DBA RJ\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"IMPDP falhando com ORA-39083 e ORA-14024 - DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Como resolver o IMPDP falhando com ORA-39083 e ORA-14024","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbarj.com.br\/pt-br\/2015\/03\/impdp-falhando-com-ora-39083-e-ora-14024\/","twitter_misc":{"Escrito por":"DBA RJ","Est. tempo de leitura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbarj.com.br\/pt-br\/2015\/03\/impdp-falhando-com-ora-39083-e-ora-14024\/#article","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/2015\/03\/impdp-falhando-com-ora-39083-e-ora-14024\/"},"author":{"name":"DBA RJ","@id":"https:\/\/www.dbarj.com.br\/pt-br\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"headline":"IMPDP falhando com ORA-39083 e ORA-14024","datePublished":"2015-03-31T02:09:33+00:00","dateModified":"2015-03-31T02:10:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/2015\/03\/impdp-falhando-com-ora-39083-e-ora-14024\/"},"wordCount":180,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"articleSection":["Oracle Database General"],"inLanguage":"pt-BR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbarj.com.br\/pt-br\/2015\/03\/impdp-falhando-com-ora-39083-e-ora-14024\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbarj.com.br\/pt-br\/2015\/03\/impdp-falhando-com-ora-39083-e-ora-14024\/","url":"https:\/\/www.dbarj.com.br\/pt-br\/2015\/03\/impdp-falhando-com-ora-39083-e-ora-14024\/","name":"IMPDP falhando com ORA-39083 e ORA-14024 - DBA - Rodrigo Jorge - Oracle Tips and Guides","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/#website"},"datePublished":"2015-03-31T02:09:33+00:00","dateModified":"2015-03-31T02:10:19+00:00","description":"Como resolver o IMPDP falhando com ORA-39083 e ORA-14024","breadcrumb":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/2015\/03\/impdp-falhando-com-ora-39083-e-ora-14024\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbarj.com.br\/pt-br\/2015\/03\/impdp-falhando-com-ora-39083-e-ora-14024\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbarj.com.br\/pt-br\/2015\/03\/impdp-falhando-com-ora-39083-e-ora-14024\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbarj.com.br\/pt-br\/"},{"@type":"ListItem","position":2,"name":"IMPDP falhando com ORA-39083 e ORA-14024"}]},{"@type":"WebSite","@id":"https:\/\/www.dbarj.com.br\/pt-br\/#website","url":"https:\/\/www.dbarj.com.br\/pt-br\/","name":"DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Blog about Databases, Security and High Availability","publisher":{"@id":"https:\/\/www.dbarj.com.br\/pt-br\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbarj.com.br\/pt-br\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":["Person","Organization"],"@id":"https:\/\/www.dbarj.com.br\/pt-br\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9","name":"DBA RJ","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","url":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","contentUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","width":712,"height":712,"caption":"DBA RJ"},"logo":{"@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png"}}]}},"_links":{"self":[{"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/posts\/1360","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/comments?post=1360"}],"version-history":[{"count":0,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/posts\/1360\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/media?parent=1360"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/categories?post=1360"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/pt-br\/wp-json\/wp\/v2\/tags?post=1360"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}