Question: I wan to know the time when a
table structure was last updated. Is there a last_ddl_time column in the
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:
where owner = 'SCOTT'
object_type = 'TABLE'
object_name = 'MY_TABLE';