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