Wednesday, April 09, 2008

Errors found in invalid objects of any schema in Oracle

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

No comments: