oracle查询数据库表最后修改时间

http://blog.csdn.net/accp_fangjian/article/details/6050527

 select uat.table_name as 表名,(select last_ddl_time from user_objects where object_name = uat.table_name ) as 最后修改日期 
     from user_all_tables uat

SELECT OBJECT_NAME ,CREATED FROM ALL_OBJECTS WHERE OBJECT_TYPE='TABLE' AND OWNER='TEST' ORDER BY CREATED DESC; ###查询表创建时间