News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Script – List all recent DDL modifications

  • Posted by Gavin Soorma
  • On July 1, 2009
  • 0 Comments
set pagesize 200 colsep ' '
col Owner format a20
col Object_Name format a30
col Last_DDL format a20
break on Owner
select Owner, Object_type
Object_Name,
Timestamp Last_DDL
from DBA_OBJECTS
where  SysDate - TO_DATE(TimeStamp,'YYYY-MM-DD:HH24:MI:SS') < 1
order by Owner, Object_Name
/
 

0 Comments

Leave Reply

Your email address will not be published. Required fields are marked *