{"id":139,"date":"2017-03-12T17:42:33","date_gmt":"2017-03-12T08:42:33","guid":{"rendered":"https:\/\/dong1lkim.oboki.net\/?p=139"},"modified":"2019-09-01T22:21:58","modified_gmt":"2019-09-01T13:21:58","slug":"tibero-how-to-compile-invalid-objects","status":"publish","type":"post","link":"https:\/\/oboki.net\/workspace\/data-engineering\/database\/tibero\/tibero-how-to-compile-invalid-objects\/","title":{"rendered":"[Tibero] How to compile Invalid Objects"},"content":{"rendered":"<p>DB Upgrade\/Patch, \ud574\ub2f9 Table\uc758 Columns \ucd94\uac00\/\uc0ad\uc81c\/\ubcc0\uacbd\uc774 \ubc1c\uc0dd\ud558\ub294 \uacbd\uc6b0 Invalid Objects\uac00 \ubc1c\uc0dd\ud560 \uc218 \uc788\ub2e4.<\/p>\n<h3>Invalid Objects Recompile \ubc29\ubc95<\/h3>\n<ol>\n<li>DBMS_DDL<\/li>\n<li>DBMS_UTILITY<\/li>\n<li>UTL_RECOMP<\/li>\n<li>UTLRP.SQL<\/li>\n<li>Manually Recompile<\/li>\n<\/ol>\n<h4>5. Manually Recompile<\/h4>\n<pre><code>ALTER OBJECT_TYPE SCHEMA.OBJECT_NAME COMPILE;\nALTER OBJECT_TYPE SCHEMA.OBJECT_NAME COMPILE BODY;\n--(View,Synonym,Public Synonym,Procedure,Function,Package,Package Body,Trigger,Undefined (Materialized View),Java Class,Type Body)\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>DB Upgrade\/Patch, \ud574\ub2f9 Table\uc758 Columns \ucd94\uac00\/\uc0ad\uc81c\/\ubcc0\uacbd\uc774 \ubc1c\uc0dd\ud558\ub294 \uacbd\uc6b0 Invalid Objects\uac00 \ubc1c\uc0dd\ud560 \uc218 \uc788\ub2e4. Invalid Objects Recompile \ubc29\ubc95 DBMS_DDL DBMS_UTILITY UTL_RECOMP UTLRP.SQL Manually Recompile 5. Manually Recompile ALTER OBJECT_TYPE SCHEMA.OBJECT_NAME COMPILE; ALTER OBJECT_TYPE SCHEMA.OBJECT_NAME COMPILE BODY; &#8211;(View,Synonym,Public Synonym,Procedure,Function,Package,Package Body,Trigger,Undefined (Materialized View),Java Class,Type Body)<\/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":[89,23,148],"class_list":["post-139","post","type-post","status-publish","format-standard","hentry","category-tibero","tag-database","tag-tibero","tag-148"],"_links":{"self":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/139","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/comments?post=139"}],"version-history":[{"count":3,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/139\/revisions"}],"predecessor-version":[{"id":1324,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/139\/revisions\/1324"}],"wp:attachment":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/media?parent=139"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/categories?post=139"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/tags?post=139"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}