728x90

1. EXEC DBMS_DDL.ALTER_COMPILE ('OBJECT_TYPE','OBJECT_OWNER','OBJECT_NAME');
2. EXEC DBMS_UTILITY.COMPILE_SCHEMA('OBJECT_OWNER');
3. EXEC UTL_RECOMP.RECOMP_SERIAL();
4. UTLRP.SQL ($ORACLE_HOME/rdbms/admin)
5. ALTER OBJECT_TYPE OBJECT_OWNER.OBJECT_NAME COMPILE;

SELECT 'ALTER '||OBJECT_TYPE||' '||OWNER||'.'||OBJECT_NAME||' COMPILE;' 
FROM DBA_OBJECTS 
WHERE OBJECT_TYPE NOT IN ('SYNONYM') AND STATUS = 'INVALID';

728x90

'ORACLE' 카테고리의 다른 글

PARTITION TABLE 크기 조회  (0) 2022.11.10
PARTITION TABLE INDEX  (0) 2022.11.08
수행한 쿼리 이력 보기  (0) 2022.10.28
DEPENDENCY  (0) 2022.10.28
JOB 조회/등록/비활성화/변경/삭제  (0) 2022.10.28

+ Recent posts