set feedback off
set heading off
set pages 0
set linesize 128
prompt These errors are found in invalid objects
select ' show err '|| object_type || ' '|| object_name
from user_objects
where status = 'INVALID';
spool error.sql
/
spool off
set feedback on
set heading on
set pages 100
@error.sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment