Lista de views que precisam ser recompiladas (Oracle)

1
2
3
4
5
6
7
8
9
10
11

SELECT
   STATUS, 
   OBJECT_TYPE, 
   OBJECT_NAME 
FROM 
   USER_OBJECTS 
WHERE 
   STATUS = 'INVALID' 
ORDER BY 
   OBJECT_NAME
;