SQL> desc all_objects; 名称 是否为空? 类型 ----------------------------------------- -------- --------------------- OWNER NOT NULL VARCHAR2(30) OBJECT_NAME NOT NULL VARCHAR2(30) SUBOBJECT_NAME VARCHAR2(30) OBJECT_ID NOT NULL NUMBER DATA_OBJECT_ID NUMBER OBJECT_TYPE VARCHAR2(19) CREATED NOT NULL DATE LAST_DDL_TIME NOT NULL DATE TIMESTAMP VARCHAR2(19) STATUS VARCHAR2(7) TEMPORARY VARCHAR2(1) GENERATED VARCHAR2(1) SECONDARY VARCHAR2(1)SQL> select created from all_objects where object_name='EMP';CREATED -------------- 30-8月 -05
USER_TAB_MODIFICATIONS These views describe tables that have been modified since the last time table statistics were gathered on them. The views are populated only for tables with the MONITORING attribute. They are not populated immediately, but after a time lapse (usually 3 hours).
USER_TAB_MODIFICATIONSUSER_TAB_MODIFICATIONS describes modifications to all tables owned by the current user that have been modified since the last time statistics were gathered on the tables. Its columns are the same as those in "ALL_TAB_MODIFICATIONS".Note:This view is populated only for tables with the MONITORING attribute. It is intended for statistics collection over a long period of time. For performance reasons, the Oracle Database does not populate this view immediately when the actual modifications occur. Run the FLUSH_DATABASE_MONITORING_INFO procedure in the DIMS_STATS PL/SQL package to populate this view with the latest information. The ANALYZE_ANY system privilege is required to run this procedure.
sys用户下执行exec DBMS_STATS.ALTER_SCHEMA_TAB_MONITORING ('用户名', TRUE); 需查看表修改时间用户下执行exec DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO; 然后select * from user_tab_modifications;
名称 是否为空? 类型
----------------------------------------- -------- ---------------------
OWNER NOT NULL VARCHAR2(30)
OBJECT_NAME NOT NULL VARCHAR2(30)
SUBOBJECT_NAME VARCHAR2(30)
OBJECT_ID NOT NULL NUMBER
DATA_OBJECT_ID NUMBER
OBJECT_TYPE VARCHAR2(19)
CREATED NOT NULL DATE
LAST_DDL_TIME NOT NULL DATE
TIMESTAMP VARCHAR2(19)
STATUS VARCHAR2(7)
TEMPORARY VARCHAR2(1)
GENERATED VARCHAR2(1)
SECONDARY VARCHAR2(1)SQL> select created from all_objects where object_name='EMP';CREATED
--------------
30-8月 -05
可以在表里添加一个字段,来记录时间。 或者通过logminer来查看归档日志。 ------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 群:62697716(满); DBA2 群:62697977(满)
DBA3 群:63306533; 聊天 群:40132017
These views describe tables that have been modified since the last time table statistics were gathered on them. The views are populated only for tables with the MONITORING attribute. They are not populated immediately, but after a time lapse (usually 3 hours).
需查看表修改时间用户下执行exec DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO;
然后select * from user_tab_modifications;
问一下,如果不执行sys用户下执行exec DBMS_STATS.ALTER_SCHEMA_TAB_MONITORING ('用户名', TRUE);
需查看表修改时间用户下执行exec DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO;
user_tab_modifications下面会有数据吗。谢谢
select * from all_objects where object_name='TABLE_NAME';
但是表的数据修改时间不知道怎么查到,
怎么去看到?