col OBJECT_NAME for a60 select owner, object_name, object_type, status from dba_objects where status <> 'VALID' order by 1, 2; --Only 11G (dba_invalid_objects) select owner, object_name, object_type, status from dba_invalid_objects where status <> 'VALID' order by 1, 2