Invalid 오브젝트의 Vaild 상태 변경을 한 방에 해주는 SQL

haisins

7년 ago

invalid -> vaild 상태 변경 한 방 SQL

SELECT distinct 'ALTER '||OBJECT_TYPE||'  '||OWNER||'.'|| OBJECT_NAME || ' COMPILE ;' as comp_command
FROM DBA_OBJECTS
WHERE STATUS = 'INVALID' 
  and Object_Type not in ( 'PACKAGE BODY','SYNONYM') 
union
SELECT distinct 'ALTER PACKAGE ' ||OWNER||'.'|| OBJECT_NAME || ' COMPILE BODY;' as comp_command
FROM DBA_OBJECTS
WHERE STATUS = 'INVALID' 
  and Object_Type in ( 'PACKAGE BODY')  ;

invalid -> vaild 상태 변경 한 방 SQL

SELECT distinct 'ALTER '||OBJECT_TYPE||' '||OWNER||'.'|| OBJECT_NAME || ' COMPILE ;' as comp_command

FROM DBA_OBJECTS

WHERE STATUS = 'INVALID'

and Object_Type not in ( 'PACKAGE BODY','SYNONYM')

union

SELECT distinct 'ALTER PACKAGE ' ||OWNER||'.'|| OBJECT_NAME || ' COMPILE BODY;' as comp_command

FROM DBA_OBJECTS

WHERE STATUS = 'INVALID'

and Object_Type in ( 'PACKAGE BODY') ;