twitter
    Find out what I'm doing, Follow Me :)

Thursday, July 1, 2010

Query to find the Last DML Operation:

(1).exec dbms_stats.flush_database_monitoring_info;

SELECT * FROM sys.DBA_TAB_MODIFICATIONS WHERE TABLE_NAME like 'TABLE_4'

(2).SELECT scn_to_timestamp(ora_rowscn) FROM EMP;

No comments:

Post a Comment