-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ -- Author : Sameer S Choudhari -- Description : Find all objects in the database order by last modification of the object i.e. LAST_DDL_TIME. -- Call Syntax : @dba_objects_ddl_modification.sql -- Last Modified: 20/03/2015 -- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ SET LINES 220 PAGES 49999 COLUMN owner FORMAT a30 COLUMN object_name FORMAT a30 SELECT owner, object_type, object_name, status, last_ddl_time FROM dba_objects ORDER BY last_ddl_time ASC, owner, object_name;