Monday, October 15, 2012

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

No comments:

Post a Comment