Question: I wan to know the time when a
table structure was last updated. Is there a last_ddl_time column in the
data dictionary?
Answer: Yes! Here is a last_ddl_time
column in dba_tables that you can query to find out
exactly when the last time a table was updated:
select
object_name,
object_type,
last_ddl_time
from
dba_objects
where owner = 'SCOTT'
and
object_type = 'TABLE'
and
object_name = 'MY_TABLE';
