Oracle Invalid Objects

Jan 20, 2016 1 min.

Get List of Invalid Objects Following query can be used to get the list of Invalid objects. SELECT object_type, object_name FROM user_objects WHERE STATUS != 'VALID' ORDER BY object_type; or SELECT owner, object_type, object_name FROM dba_objects WHERE STATUS != 'VALID' ORDER BY owner, object_type; Compile Invalid Objects Following SQL block can be used for compiling invalid objects DECLARE sql_statement varchar2(500); BEGIN dbms_output.put_line(chr(0)); dbms_output.put_line('Re-compilation of Invalid Objects'); dbms_output.put_line('---------------------------------'); dbms_output.put_line(chr(0)); FOR invalid in (SELECT object_type, object_name FROM user_objects o WHERE o.