A snippet of SQL to find the change time of an Oracle object in the
database.
-- Get the name, type, date of change of the DDL of a user object.
select OBJECT_NAME, OBJECT_TYPE, LAST_DDL_TIME from dba_objects where
owner not in ('SYS','SYSTEM');
------------------- cut here -----------------------------------