find the time of the last DDL statement that has been applied on a table.

SELECT object_name, object_type, last_ddl_time
 
FROM dba_objects (or all_objects)
 
WHERE owner = <<owner of table>>
   
AND object_name = 'MY_TABLE'

Thank you
Osama mustafa

One thought on “find the time of the last DDL statement that has been applied on a table.

Leave a Reply to kevingeorge Cancel reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.