OracleでINVALIDなオブジェクトを表示するSQL

使い方

sqlplus -S usr/password@tnsname < show_invalid_objects.sql

show_invalid_objects.sql

column OBJECT_TYPE format A20
column OBJECT_NAME format A50

select OBJECT_TYPE, OBJECT_NAME from USER_OBJECTS
where STATUS = 'INVALID'
order by OBJECT_TYPE, OBJECT_NAME;