Oracle: Script to find invalid objects, errors and way to compile

oracle-invalid-db-objects.sql

-- Query to find the invalid user objects in Oracle DB
SELECT OBJECT_NAME,
  OBJECT_TYPE,
  STATUS
FROM USER_OBJECTS
WHERE object_type IN ('PROCEDURE', 'TRIGGER', 'TABLE', 'VIEW', 'FUNCTION', 'INDEX')
AND STATUS         ='INVALID';

--Query to find database view errors in the Oracle DB.
SELECT * FROM ALL_ERRORS WHERE TYPE = 'VIEW' ORDER BY SEQUENCE ASC;

-- Recompile a view
ALTER VIEW <VIEW_NAME> COMPILE;