Tuesday 26 January 2016

Invalid objects details in oracle database

Below script to know the invalid objects count and details including (creation date, modification date and user details).

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