Below script to know the invalid objects count and details including (creation date, modification date and user details).
Script:
Script:
set linesize 200 column owner format a12 col columnname format a20 column object_name format a30 column object_type format a15 column "Created" format a21 column "Last DDL Time" format a21 select owner, object_name, object_type, status, to_char(created, 'DD-MON-YYYY HH:MI AM') "Created", to_char(last_ddl_time, 'DD-MON-YYYY HH:MI AM') "Last DDL Time" , timestamp from dba_objects where status = 'INVALID' order by owner, object_name;
Output:
No comments:
Post a Comment