# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1365086015 -10800
# Node ID 752e99dbb0169301aa272ed1de259333cdc45660
# Parent  20964d8677d72bc57ccb6a10ccd22c97738d3591
Last table modification time.

diff -r 20964d8677d7 -r 752e99dbb016 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.
 ==============================