ckerrors.sql
REM *************************************************************************** REM REM TITLE: REM AUTHOR: REM DESCRIPTION: REM REM REM REM USAGE W/ PARAMETERS: REM REM TABLES USED: REM REM MODIFICATION ALLOWED (Y/N): REM MODIFICATION HISTORY: REM WHO WHEN WHAT REM -------------------------------------------------------------------------- REM MM/DD/YY INITIAL CREATION REM REM *************************************************************************** rem derrors.sql rem col owner noprint col name noprint col type noprint rem col line format 999 col position format 999 heading 'POS' col text format a70 wrap rem select owner, name, type, line, position, text from sys.dba_errors where owner like upper('%&owner%') and name like upper('%&name%');