CentOS 사전 준비 및 오라클 다운로드 CentOS 패키지 설치 ##yum_for_oracle12c.sh yum update -y yum install binutils -y yum install compat-libcap1 -y yum install compat-libstdc++-33 -y yum install compat-libstdc++-33.i686 -y yum install gcc -y yum install gcc-c++ -y yum install glibc -y yum install glibc.i686 -y yum install glibc-devel -y yum install glibc-devel.i686 -y yum install ksh […]
[Tibero] How to compile Invalid Objects
DB Upgrade/Patch, 해당 Table의 Columns 추가/삭제/변경이 발생하는 경우 Invalid Objects가 발생할 수 있다. Invalid Objects Recompile 방법 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; –(View,Synonym,Public Synonym,Procedure,Function,Package,Package Body,Trigger,Undefined (Materialized View),Java Class,Type Body)