실습용 예제 user,table 생성 #!/bin/bash #2017/03/29 #testcase_mig_fk.sh #dong1lkim TBL_CNT=0 #init TBL_CNT while (($TBL_CNT <= 500)) do PKTAB_NAME=TBL_PKTEST_echo $TBL_CNT FKTAB_NAME=TBL_FKTEST_echo $TBL_CNT sh cre_fktab.sh echo $filename ROW_CNT=0 #init cnt while (($ROW_CNT <= 500)) do sh insert_val_fktab.sh let ROW_CNT+=1 done let TBL_CNT+=1 echo -e “loop ends” done #!/BIN/BASH #2017/03/29 #cre_fktab.sh #DONG1LKIM tbsql -s fktest2/tibero <<EOF –SET ECHO ON […]
[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)