Last table modification time.
--- a/oracle.rst Thu Apr 04 17:32:02 2013 +0300
+++ b/oracle.rst Thu Apr 04 17:33:35 2013 +0300
@@ -88,6 +88,14 @@
$SQL lists statistics on shared SQL area without the GROUP BY
clause.
+Last table modification time.
+=============================
+::
+
+ select max(scn_to_timestamp(ora_rowscn)) from TBL;
+
+ select timestamp from all_tab_modifications where table_owner = 'OWNER';
+ select timestamp from all_tab_modifications where table_name = 'TABLE';
List of Oracle Reserved Words.
==============================