- select uat.table_name,(select last_ddl_time
- from user_objects
- where object_name = uat.table_name) as lastddltime
- from user_all_tables uat
- order by lastddltime
- select uat.table_name,(select last_ddl_time
- from user_objects
- where object_name = uat.table_name) as lastddltime
- from user_all_tables uat
- order by lastddltime
