Query:
===================
set lines 300
col owner for a20
col OBJECT_NAME for a30
select owner,object_name,object_id,object_type,status,last_ddl_time,created from dba_objects where status='INVALID' order by owner;
===================
set lines 300
col owner for a20
col OBJECT_NAME for a30
select owner,object_name,object_id,object_type,status,last_ddl_time,created from dba_objects where status='INVALID' order by owner;

No comments:
Post a Comment