Tuesday, January 29, 2013

Oracle Changed Objects


set pages 50
set lines 140
col owner       heading 'Owner'   format a15
col object_name heading 'Object'  format a30
col object_type heading 'Type'    format a15
col last_ddl    heading 'Changed' format a15
select owner,
       object_name,
       object_type,
       to_char(last_ddl_time,'dd-mon-yy hh24:mi') last_ddl
  from dba_objects
 where owner not in ('SYS','SYSTEM')
   and trunc(last_ddl_time) >= trunc(sysdate-1) and trunc(last_ddl_time) < trunc(sysdate)
/

No comments:

Post a Comment