set lines 300 set pages 30000 column object_type format a30 column object_name format a30 column owner format a30 column FCREACION format a20 column FLAST_DDL format a20 alter session set nls_date_format='ddmmyyyy hh24:mi:ss'; select owner,object_name,object_type,status from dba_objects where owner like upper('&1') and status = 'INVALID' order by owner,object_type,object_name;