«
»

Howto find when table was last updated in Oracle.

June 24, 2010, 10:06 am

Reading time: < 1 minute

SQL> select scn_to_timestamp(max(ora_rowscn)) from WRH$_FILESTATXS;
SCN_TO_TIMESTAMP(MAX(ORA_ROWSCN))
---------------------------------------------------------------------------
24-JUN-10 11.00.10.000000000 AM
  • Share/Bookmark
Category: Oracle  |  Comment (RSS)  |  Trackback

One Comment

  1. Mis Compartidos en Google Reader - June 29, 2010 - webmatica.cl says:
    June 29, 2010 at 3:59 pm

    [...] Howto find when table was last updated in Oracle. [...]

Leave a Reply