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 |