dba_errors_all.sql

-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Author       : Sameer S Choudhari
-- Description  : Report the errors on the stored objects (i.e. PL/SQL,Views,Triggers,etc.) in the database.
-- Call Syntax  : @dba_errors_all.sql
-- Last Modified: 20/06/2017
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SET LINES 220 PAGES 49999
COLUMN TYPE FORMAT a20
COLUMN OWNER FORMAT a30
COLUMN NAME FORMAT a30
COLUMN text FORMAT a60
SELECT *
FROM dba_errors
ORDER BY
  TYPE,
  OWNER,
  NAME;