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

ALL_OBJECTS包含有关您拥有权限的所有对象的信息(即您至少可以从中选择的表). DBA_OBJECTS包含有关数据库中所有对象的信息,无论您是否有权访问它们.但是,访问DBA_OBJECTS视图需要其他权限.