Last table modification time.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Thu, 04 Apr 2013 17:33:35 +0300
changeset 1485 752e99dbb016
parent 1484 20964d8677d7
child 1486 f3be7476145d
Last table modification time.
oracle.rst
--- 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.
 ==============================