Finding last updated date of a table RRS feed

  • Question

  • User-182690678 posted

    Dear Team,

    How to find when table was last updated in Oracle.

    Below query working fine in DEV Database the same is giving problem in PROD

    select to_char(scn_to_timestamp(max(ora_rowscn))) from EMP

    Getting below error in PROD

    ORA-08181: SPecified number is not a valid system change number

    Monday, July 18, 2011 7:58 AM


  • User1666665689 posted

    Dear Friend,

    Check with the URL below:


    This will help you get the last updated record from a table.

    Thanks and Regards,


    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, July 18, 2011 8:08 AM