locked
Finding last updated date of a table RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    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

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    User1666665689 posted

    Dear Friend,

    Check with the URL below:

    http://blog.sqlauthority.com/2009/05/09/sql-server-find-last-date-time-updated-for-any-table/

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

    Thanks and Regards,

    G.V.N.Sandeep

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