REM
/*
 * TableLastUpdate.Sql (c) Tim Onions 2007
 * Please check this script works as expected on a test system before using on a production database.
 * The author can accept no liability or responsibility for any ill-effect it may have.
 * You are free to use this script on one condition - use it to improve the performance of your database!
 */

SELECT scn_to_timestamp(max(ora_rowscn))
FROM &t
/

SET DOC off
/*
 * SUMMARY - Use block SCN to show approximately when a table last updated.
 * Acknowledgements to jeremy.schneider from the oracle-l discussion group.

For tables modified more than 5 days ago you can see the SCN but cannot
translate into a timestamp.  (At least, according to metalink note 361480.1)

 *
 * DETAIL - 
 * (c) Tim Onions 2007
 * Script used at the database owners risk.
 */

REM