Neste artigo, vamos compartilhar uma situa\u00e7\u00e3o de erro ORA-39151 durante processo de IMPDP, e como foi a sua solu\u00e7\u00e3o.<\/p>\n\n\n\n
Havia realizado inicialmente um EXPDP de um owner espec\u00edfico, conforme par\u00e2metros abaixos:<\/p>\n\n\n
\nUSERID=system\/SENHA\nSCHEMAS=OWNER\nDIRECTORY=BSS\nDUMPFILE=EXP_OWNER.dmp\nLOGFILE=EXP_OWNER.log\n<\/pre><\/div>\n\n\nO export deste owner foi realizado com sucesso:<\/p>\n\n\n
\nDump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:\n \/diretorio\/OWNER\/EXP_OWNER.dmp\nJob "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at 09:38:41\n<\/pre><\/div>\n\n\nJ\u00e1 os par\u00e2metros do IMPDP foram:<\/p>\n\n\n
\nUSERID=system\/OUTRASENHA\nSCHEMAS=OWNER\nDIRECTORY=BSS\nDUMPFILE=EXP_OWNER.dmp\nLOGFILE=IMP_OWNER.log\nREMAP_TABLESPACE=USERS:TSPC_OWNER\n<\/pre><\/div>\n\n\nPor\u00e9m, durante o processo de import, as mensagens abaixo eram exibidas no Log:<\/p>\n\n\n
\nORA-31684: Object type TYPE:"OWNER"."TYPE" already exists\n...\n \nORA-39151: Table "OWNER"."TABELA" exists. All dependent metadata and data will be skipped due to table_exists_action of skip\n...\n \nProcessing object type SCHEMA_EXPORT\/PACKAGE\/PACKAGE_SPEC\nORA-31684: Object type PACKAGE:"OWNER"."PACK" already exists\n...\n \nProcessing object type SCHEMA_EXPORT\/FUNCTION\/FUNCTION\nORA-31684: Object type FUNCTION:"OWNER"."FUNC" already exists\n...\n \nProcessing object type SCHEMA_EXPORT\/PROCEDURE\/PROCEDURE\nORA-31684: Object type PROCEDURE:"OWNER"."PROC" already exists\n...\n \nProcessing object type SCHEMA_EXPORT\/VIEW\/VIEW\nORA-31684: Object type VIEW:"OWNER"."VIEW" already exists\n...\n \nProcessing object type SCHEMA_EXPORT\/VIEW\/GRANT\/OWNER_GRANT\/OBJECT_GRANT\nORA-39111: Dependent object type OBJECT_GRANT:"OWNER" skipped, base object type VIEW:"OWNER"."VIEW" already exists\n...\n \nProcessing object type SCHEMA_EXPORT\/PACKAGE\/PACKAGE_BODY\nORA-31684: Object type PACKAGE_BODY:"OWNER"."PKG" already exists\n...\n \nProcessing object type SCHEMA_EXPORT\/TYPE\/TYPE_BODY\nORA-31684: Object type TYPE_BODY:"OWNER"."TP" already exists\n...\n \nProcessing object type SCHEMA_EXPORT\/TABLE\/TRIGGER\nORA-39083: Object type TRIGGER:"OWNER"."TRG" failed to create with error:\nORA-04020: deadlock detected while trying to lock object OWNER\n...\n \nORA-39083: Object type TRIGGER:"OWNER"."TRG2" failed to create with error:\nORA-00942: table or view does not exist\n...\n \nORA-39083: Object type TABLE_STATISTICS failed to create with error:\nORA-20000: TABLE "OWNER"."TAB" does not exist or insufficient privileges\n<\/pre><\/div>\n\n\nAl\u00e9m disso, ao comparar a quantidade de objetos desse owner na origem e destino, perceb\u00edamos diferen\u00e7a de n\u00famero (faltando objetos no destino).<\/p>\n\n\n\n
Para resolver a situa\u00e7\u00e3o, adicionamos o par\u00e2metro CONSISTENT=Y no EXPDP, e disparamos novamente o processo de export:<\/p>\n\n\n
\nUSERID=system\/SENHA\nSCHEMAS=OWNER\nDIRECTORY=BSS\nDUMPFILE=EXP_OWNER1.dmp\nLOGFILE=EXP_OWNER1.log\nCONSISTENT=Y\n<\/pre><\/div>\n\n\nExport finalizado com sucesso:<\/p>\n\n\n
\nDump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:\n \/diretorio\/OWNER\/EXP_OWNER1.dmp\nJob "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at 10:49:46\n<\/pre><\/div>\n\n\nJ\u00e1 no IMPDP, n\u00e3o precisamos adicionar ou alterar nenhum par\u00e2metro. Ap\u00f3s o disparo do import, notamos que os erros que eram exibidos antes, n\u00e3o estavam mais acontecendo, e o processo finalizou com sucesso e a quantidade de objetos entre origem e destino ficou a mesma.<\/p>\n","protected":false},"excerpt":{"rendered":"
Neste artigo, vamos compartilhar uma situa\u00e7\u00e3o de erro ORA-39151 durante processo de IMPDP, e como foi a sua solu\u00e7\u00e3o. Havia realizado inicialmente um EXPDP de um owner espec\u00edfico, conforme par\u00e2metros abaixos: O export deste owner foi realizado com sucesso: J\u00e1 os par\u00e2metros do IMPDP foram: Por\u00e9m, durante o processo de import, as mensagens abaixo eram […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5462","post","type-post","status-publish","format-standard","hentry","category-administration"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/5462","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=5462"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/5462\/revisions"}],"predecessor-version":[{"id":9101,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/5462\/revisions\/9101"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=5462"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=5462"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=5462"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}