{"id":1020,"date":"2020-07-10T09:06:28","date_gmt":"2020-07-10T12:06:28","guid":{"rendered":"http:\/\/rodrigosilvaesilva.com.br\/?p=1020"},"modified":"2020-07-10T09:06:28","modified_gmt":"2020-07-10T12:06:28","slug":"ora-39082-object-type-procedure-ora-39082-object-type-trigger","status":"publish","type":"post","link":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/2020\/07\/10\/ora-39082-object-type-procedure-ora-39082-object-type-trigger\/","title":{"rendered":"ORA-39082: Object type PROCEDURE: ORA-39082: Object type TRIGGER:"},"content":{"rendered":"<p>Bom dia pessoal! Hoje me deparei com um cliente com a seguinte situa\u00e7\u00e3o:<\/p>\n<p>Ao realizar o impdp v\u00e1rias TRIGGERS e PROCEDURES ficaram invalidadas.<\/p>\n<h2>Resolvendo erro ORA-3902<\/h2>\n<pre class=\"lang:sh decode:true\">ORA-39082: Object type PROCEDURE:\"NAME\".\"STP_GRAVATABLOG\" created with compilation warnings\nORA-39082: Object type PROCEDURE:\"NAME\".\"STP_GRAVA_TSIPARLOG\" created with compilation warnings\nORA-39082: Object type PROCEDURE:\"NAME\".\"DESABILITA_TRG_TAB\" created with compilation warnings\nORA-39082: Object type PROCEDURE:\"NAME\".\"HABILITA_TRG_TAB\" created with compilation warnings\nORA-39082: Object type PROCEDURE:\"NAME\".\"STP_GRAVATABLOG\" created with compilation warnings\nORA-39082: Object type PROCEDURE:\"NAME\".\"STP_GRAVA_TSIPARLOG\" created with compilation warnings\nORA-39082: Object type PROCEDURE:\"NAME\".\"DESABILITA_TRG_TAB\" created with compilation warnings\nORA-39082: Object type PROCEDURE:\"NAME\".\"HABILITA_TRG_TAB\" created with compilation warnings\nORA-39082: Object type TRIGGER:\"NAME\".\"TRG_DLT_TGFFIN_EXCLUSAO\" created with compilation warnings\nORA-39082: Object type TRIGGER:\"NAME\".\"TRG_UPD_DLT_TGMTME_EXCLUSAO\" created with compilation warnings\nORA-39082: Object type TRIGGER:\"NAME\".\"TRG_DLT_TGFMBC_EXCLUSAO\" created with compilation warnings\nORA-39082: Object type TRIGGER:\"NAME\".\"TRG_DLT_TGFLIV_EXC\" created with compilation warnings\nORA-39082: Object type TRIGGER:\"NAME\".\"TRG_INS_TGWLOG\" created with compilation warnings\nORA-39082: Object type TRIGGER:\"NAME\".\"TRG_INS_TSILOG\" created with compilation warnings\nORA-39082: Object type TRIGGER:\"NAME\".\"TRG_DLT_TGFITE\" created with compilation warnings\nORA-39082: Object type TRIGGER:\"NAME\".\"TRG_DLT_TGFTEF_EXCLUSAO\" created with compilation warnings\nORA-39082: Object type TRIGGER:\"NAME\".\"TRG_INC_UPD_DLT_TFPVPS_LOG\" created with compilation warnings\nORA-39082: Object type TRIGGER:\"NAME\".\"TRG_DLT_TGFCAB\" created with compilation warnings\nORA-39082: Object type TRIGGER:\"NAME\".\"TRG_TSIPAR_LOG\" created with compilation warnings\nORA-39082: Object type TRIGGER:\"NAME\".\"TRG_UPD_DLT_TGMMSG_EXCLUSAO\" created with compilation warnings\nORA-39082: Object type TRIGGER:\"NAME\".\"TRG_DLT_TGFNUM\" created with compilation warnings\n<\/pre>\n<p>&nbsp;<\/p>\n<h2>Concedendo permiss\u00f5es para o usu\u00e1rio NAME<\/h2>\n<pre class=\"lang:sh decode:true\">GRANT SELECT ON V_$SESSION TO NAME \n\/ \nGRANT SELECT ON DBA_TABLES  TO NAME \n\/ \nGRANT CREATE SESSION TO NAME \n\/ \nGRANT SELECT ON DBA_TAB_COLUMNS TO NAME \n\/ \nGRANT SELECT ON DBA_CONSTRAINTS  TO NAME \n\/ \nGRANT SELECT ON DBA_TRIGGERS TO NAME \n\/ \nGRANT SELECT ON DBA_INDEXES TO NAME \n\/ \nGRANT SELECT ON DBA_VIEWS  TO  NAME \n\/ \nGRANT SELECT ON DBA_IND_COLUMNS TO NAME \n\/ \nGRANT SELECT ON DBA_OBJECTS TO NAME  \n\/ \nGRANT EXP_FULL_DATABASE TO NAME \n\/ \nGRANT IMP_FULL_DATABASE TO NAME<\/pre>\n<h2><strong>Rebuild objetos inv\u00e1lidos<\/strong><\/h2>\n<pre class=\"lang:plsql decode:true\">EXEC DBMS_UTILITY.compile_schema(schema =&gt; 'NAME')\n<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bom dia pessoal! Hoje me deparei com um cliente com a seguinte situa\u00e7\u00e3o: Ao realizar o impdp v\u00e1rias TRIGGERS e PROCEDURES ficaram invalidadas. Resolvendo erro ORA-3902 ORA-39082: Object type PROCEDURE:&#8221;NAME&#8221;.&#8221;STP_GRAVATABLOG&#8221; created with compilation warnings ORA-39082: Object type PROCEDURE:&#8221;NAME&#8221;.&#8221;STP_GRAVA_TSIPARLOG&#8221; created with compilation warnings ORA-39082: Object type PROCEDURE:&#8221;NAME&#8221;.&#8221;DESABILITA_TRG_TAB&#8221; created with compilation warnings ORA-39082: Object type PROCEDURE:&#8221;NAME&#8221;.&#8221;HABILITA_TRG_TAB&#8221; created&#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":[67,84,88,89,90,100,135,152,269,270,330,373],"class_list":["post-1020","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-created-with-compilation-warnings","tag-dba_constraints","tag-dba_tab_columns","tag-dba_tables","tag-dba_triggers","tag-dbms_utility-compile_schema","tag-exp_full_database","tag-imp_full_database","tag-ora-39082-object-type-procedure","tag-ora-39082-object-type-trigger","tag-session","tag-v_session"],"_links":{"self":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1020","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=1020"}],"version-history":[{"count":0,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1020\/revisions"}],"wp:attachment":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=1020"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=1020"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=1020"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}