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

Comments

  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

Post a Comment

Popular posts from this blog

Connection refused; No available router to destination On Weblogic Node Manager Log

How to change SGA in Oracle Rac

SGA_MAX_SIZE & SGA_TARGET / MEMORY_TARGET & MEMORY_MAX_TARGET