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

1 comment:

  1. Thank you a lot for providing individuals with a very spectacular possibility to read critical reviews from this site.

    oracle training in bangalore


    ReplyDelete