[Tibero] How to compile Invalid Objects

DB Upgrade/Patch, 해당 Table의 Columns 추가/삭제/변경이 발생하는 경우 Invalid Objects가 발생할 수 있다.

Invalid Objects Recompile 방법

1. DBMS_DDL
2. DBMS_UTILITY
3. UTL_RECOMP
4. UTLRP.SQL
5. Manually Recompile

5. Manually Recompile

ALTER OBJECT_TYPE SCHEMA.OBJECT_NAME COMPILE;
ALTER OBJECT_TYPE SCHEMA.OBJECT_NAME COMPILE BODY;
--(View,Synonym,Public Synonym,Procedure,Function,Package,Package Body,Trigger,Undefined (Materialized View),Java Class,Type Body)