✦

Technology Geek

18+ YEARS AMONG THE CLOUDS

✦ TRANSMISSION

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 response to “find the time of the last DDL statement that has been applied on a table.”

  1. kevingeorge

    Thank you a lot for providing individuals with a very spectacular possibility to read critical reviews from this site.oracle training in bangalore

    Like

    Reply

Leave a comment

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